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