Highlight current date

[Xirom431]

Hi,

My sheet has multiple date row with the format mm/dd/yyyy hhmm. They can be in different column. The time will change. How do I highlight green the yesterday when I open the file each time? Any help will be greatly appreciate.

Thanks

 

[etaf]

conditional formatting will do that
=INT(C1)=Today()
BUT anything else in the file to identify the row with the date in
as its seems to be in various rows - is there a cell which identifies the row that can be used

Book1
	C
1	2/1/21 7:00
2
3
4
5
6	10/20/22 11:00
7
8
9
10	10/21/22 13:30
11
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C1,C6,C10	Expression	=INT(C1)=TODAY()	text	YES