Change Color of cell based on specific letter / text

[steven_e]

Can anyone give VBA help on creating a macro?

To search the entire sheet and if any cell contains just an "A" turn the cell green. If it contains just an "R" turn the cell red.

If the cells contain anything thing else, do nothing.
For example "AM" then no change.

I can do this is conditional formatting, but I need a macro for it.

[mehmetcik]

Hi

This could be simplified by making a loop to find A and color then find R and color using a subroutine.

But thats a job for you.

Enjoy

Please Login or Register  to view this content.