conditional formating not functioning in cell with formula?
hi John I already figure it out my second question adding Sunday thanks on
the list to be formatted thanks!
"John C" wrote:
Because although SAT is displayed, the cell value is still the date.
Try the following (assuming in cell B2):
Conditional Formatting
Change dropdown to Formula is:
=WEEKDAY(B2)=7
add your formatting preference.
Hope that helps.
--
John C
"Excel" wrote:
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
|