Hi,

I see the solution on the boards but it doesn't work for me.

Cells:

B1 =now()
B2 =weekday(b1)
C2 Conditional formatting =b2="Monday"

Cell B2 is custom formatted "dddd" so it shows the day.

If I type "Monday" into cell B2 it works but if I use "weekday(b1)" it
doesn't even though "Monday" is in the cell. How do I get conditional
formatting to recognize the value Monday as opposed to being confused
by the formula?