If there is no data in the cell for the current date, then color the cells with color. How to do?

Question

excel

Good afternoon!
Column A contains last names
Row 1 contains dates
How to use conditional formatting to make sure that if there is no data in the cell for the current date (today), the cell with the last name is tinted with color

A when September 18 comes, the cells are repainted all, until data will not be entered

Answer 1

Something like this:

=И(
  ДВССЫЛ("RC"&ПОИСКПОЗ(СЕГОДНЯ();$1:$1;0);0)="";
  ДВССЫЛ("RC";0)<>""
)

Demo table

Answer 2

It's possible, see screenshot.