Code to color selected ws cells

  • Thread starter Thread starter James A
  • Start date Start date
J

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
 
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.
 
Back
Top