Displaying text

[gauca001]

I am building a macro (below) which changes the text "This is Brown colour" to "Brown" in col D. This works perfect. now in Col G (same row) I need to add "A" if the result in D is "Brown" and "B" if the result in D is "Red". Please help.

Please Login or Register  to view this content.

[patel45]

Please Login or Register  to view this content.

[gauca001]

Hi Thanks for your answer but I need the results A and B in every cell in col G where the words red and brown are displayed in col D.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.