conditional formating not functioning in cell with formula?

[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

 

[John C]

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.

 

[Excel]

thanks John, one more question if ill be including the Sun, what formula will
i be using?

 

[Excel]

hi John I already figure it out my second question adding Sunday thanks on
the list to be formatted thanks!

 

[John C]

Thanks for the feedback, and don't forget to check the little YES box below