Code to color selected ws cells
 

I would be grateful if someone would go a little further
to help me with a macros or VBA code.
The actual scenario is this: I have a worksheet that
contains cells with words like SD00, MM04 etc. I want to
color all cells containing say SD00
yellow and MM04 red .....

Regards,
JKA

Code to color selected ws cells
 

James,
Glad you came back to the ng. However, you should stay in the original
thread.
If you have 3 or less conditions you can use conditional formatting
formatconditional formattingcell is equal toSD00
If more you need a macro
select case would be good.

"James A" wrote in message
...
I would be grateful if someone would go a little further
to help me with a macros or VBA code.
The actual scenario is this: I have a worksheet that
contains cells with words like SD00, MM04 etc. I want to
color all cells containing say SD00
yellow and MM04 red .....

Regards,
JKA