View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SandyB SandyB is offline
external usenet poster
 
Posts: 7
Default conditional formatting

I have a column in which each cell has the option to contain one of six
different words. Based on which word is selected, I need 2 to 3 other cells
in the same row to change to a yellow highlight.

For example, if cell C2 contains the word flat, then I need cells H2 and I2
to become yellow.

But, If cell C2 contains the word 2FC, then I2, J2 and L2 need to be yellow.
--
Please let me know if this can be done - I have 6 different variables.
SandyB