Conditional Format to change cell depending on date

[still learning]

Hi
I'm having a brain freeze...if I even have a brain
AY4:AY415 has dates in them from 1/1/2024 to 12/31/2024
Some of AZ4:AZ415 have text in them
I'm trying to have conditional format change the font to red in AZ4:AZ415 if the same line cell is today's date
It doesn't matter if there isn't any text in some AZ because nothing will happen
I highlighted all of AZ4:AZ415 ...I tried

=(AY4=today())

and it doesn't work
I also tried

=($AY$4=today())

Example: if the date in AY4 = today() ..i want the AZ4 font to be red...if it's not today, I want it default (black)

mike

 

[PeteWright]

Book1.xlsx
	AY	AZ
36	2/2/2024	pqr
37	2/3/2024
38	2/4/2024
39	2/5/2024	stu
40	2/6/2024
41	2/7/2024	vwxyz
42	2/8/2024
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
AZ4:AZ42	Expression	=$AY4=TODAY()	text	NO

This works for me

=$AY4=TODAY()

but I tested both of your conditional formatting rules and they also did their job.

Maybe your cells aren't formatted as Dates.
Can you check that?

 

[still learning]

thanks PeteWright
I used what you use and it worked perfectly.
I made a sample sheet and tried both of what i thought didn't work...and it worked.. wierd

mike