Worked perfectly - thank you.

"Toppers" wrote:

Highlight rows
CF
Formula is: =$a1=Today()

select colour

OK

"munch" wrote:

I'm using Excel for scheduling employees. The spreadsheet is set up for the
entire month with each day's date in column A. How do I create conditional
formatting to automatically highlight the row containing "today's" date?