Highlighting entire column of data based of a date at the top

[JohnKJK81]

I have a sheet with dates for the month in a across a row, E17 thru AI17.

Wanting to highlight the data down the column that has todays date in the corresponding column of row E.

I can't figure out the formula in conditional formatting to use for that.

Can you let me know the formula or if that's not possible?

 

[Fluff]

Hi & welcome to MrExcel.
Select the data from E18 AI last row & use this formula

=E$17=TODAY()

 

[etaf]

ignore answered

 

[JohnKJK81]

Thank you!

 

[Fluff]

Glad we could help & thanks for the feedback

 

[JohnKJK81]

I apologize my question wasn't explained well...

The dates in the month are in a row across E17 thru AI17.

So for instance G17 is TODAY, so wanting all the cells below G17 to be highlighted. (they are not dates below row 17, just data.

 

[etaf]

Select E18:AI30000 - or however many rows you have
Then use
Fluff formula

see here

Book1
	E	F	G	H	I	J	K	L
17	8/23/21	8/24/21	8/25/21	8/23/21	8/26/21	8/23/21	8/23/21	8/23/21
18
19
20
21
22
23
24
25
26
27
28
Sheet1

Cell Formulas
Range	Formula
E17,H17,J17:L17	E17	=TODAY()-2
F17	F17	=TODAY()-1
G17	G17	=TODAY()
I17	I17	=TODAY()+1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
E18:L28	Expression	=E$17=TODAY()	text	NO