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

conditional formating not functioning in cell with formula?
 

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

conditional formating not functioning in cell with formula?
 

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

"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

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

conditional formating not functioning in cell with formula?
 

Thanks for the feedback, and don't forget to check the little YES box below :)
--
John C


"Excel" wrote:

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