can't get conditional format to work

[still learning]

Hi

I have Monday in B2

I have Tuesday in b3

I have Wednesday in B4

I have Thursday in B5

I'm trying to get the current day of the week to change font color

I tried to highlight the row from B2:B5 and use this formula but it doesn't work

=B2=today()

If I change the cells to a date and change the font to “dddd” it works

What am I doing wrong

mike

 

[still learning]

I just found out that it only works if I use today's date for wednesday (4/17) it works.
if I use any other date, it doesn't.
SO .... my solution is no good
Hey.....first mistake today !!!!!

mike

 

[Alex Blakenburg]

How about:

=B2=TEXT(TODAY(),"dddd")

Note: I would personally put Today() in a cell and reference that cell (absolute referencing) instead of putting Today directly in the formula. Putting it in a cell will also help you in testing it.

 

[welshgasman]

I just found out that it only works if I use today's date for wednesday (4/17) it works.
if I use any other date, it doesn't.
SO .... my solution is no good
Hey.....first mistake today !!!!!

mike

You are comparing a week day name against a date?
You would also need to use the WeekDay() function and format as you have done.
I would also enter that in a cell and refer to that cell in the CF.

 

[still learning]

Hi

Thank you Alex and Welsgasman
Using you suggestions

What I did was make a helper cell (G1) and put in

=Today()

Then I made another helper cell (A1) and put in

=TEXT(G1,”dddd”)

Then I used Conditional format to reference A1

=B2=$A$1

And applied it to B2:B5
And so far it works !!!
I also tried ..in helper cell A1…

=TEXT(Today(),”dddd”)

And the result is also today’s day name
So now I can have the headings change color depending on the day of the week. It makes it a little easier to see what day it is.


mike

 

[Alex Blakenburg]

Thanks for letting us know. Glad we could help.

 

[welshgasman]

I would replace G1 in the A1 cell with Today()
Why have two cells, when you only need one?

 

[still learning]

Yep...that's what I did
Thanks again

mike