View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
B G
 
Posts: n/a
Default Change row color based on condition of celss

I would like to make the row color turn red based on the follow condition:

If the value in column P (all rows) is less than the value in column Y then
I want to change the color of the row to Red.

I know this is in condiitional formating but I cannot get it to work. I am
a very basic excel user so am not familiar with all the ins and outs. Any
help would be appreciated.
--
Barb