conditional formating not functioning in cell with formula?

  • Thread starter Thread starter Excel
  • Start date Start date
E

Excel

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
 
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.
 
hi John I already figure it out my second question adding Sunday thanks on
the list to be formatted thanks!
 
Back
Top