conditional format to change a cell fill if another cell has today's date

[still learning]

Hi
I'm having a brain fart
I can't get the formula to work
Conditional Format
if B2 has today's date, change cells C2:E2 fill to red
I then will drag it down to B200....C200:E200.
I tried
=if(B2=today())
and B2=today()

mike

 

[jtakw]

Hi,

It should just be

=$B$2=TODAY()

If that doesn't work, how is B2 populated?

 

[still learning]

Hi jtakw
That works, BUT only if I format the cells correctly. I had formated the font instead of fill
Maybe it's time to start over tomorrow.

B2 has 3/9/2022 and is formated as D

thanks

mike

 

[jtakw]

You're welcome, glad you got it to work.