View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Trevor Shuttleworth Trevor Shuttleworth is offline
external usenet poster
 
Posts: 1,089
Default can i setup if, then statements to change the color of a row

Use Conditional Formatting with the three conditions.

Regards

Trevor


"Ed" wrote in message
...
I would like to use if and then statements to recognize P, O, or C
if the cell has P, O, or C I want the row to change colors Blue, Green,
Red
Is this possible