How to conditional format a row in excel containing todays daye?
I have my worksheet in Excel where I keep track of my dates and hours worked. Column A, down, has the dates starting from 1/1/2022 to 12/31/2022. There is other data in each ROW across associated with the date that I would like to highlight also, for example, today is column A, the coinciding day of the week, then time on duty, time off, where I worked. example:
1/1/2022 Saturday 0600 1200 6:00 Morrisville
1/2/2022 Sunday 0000 0000 0:00 off duty
1/3/2022 Monday 1200 2200 10:00 Camden
i would like to have excel, based on "today()" highlight the row across from column A thru Column H with a color, etc.
|