Code to color selected ws cells

[James A]

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

 

[Don Guillett]

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
format>conditional formatting>cell is equal to>SD00
If more you need a macro
select case would be good.