View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
excel excel is offline
external usenet poster
 
Posts: 6
Default conditional formating not functioning in cell with formula?


hi

My question is how can i put a font color on cell if day = sat.

Scenario is

Cell A1 = 10/11
Cell B1 = Sat ( i used custom formating ddd - to change the date to days
in reference to A1 = cell B1(=A1)

but when i used conditional formating:

cell value is equal to SAT, it doesnt change the font color?

i