View Single Post
 
Old 01-01-2022, 06:14 AM
cwkotch cwkotch is offline Windows 10 Office 2019
Novice
 
Join Date: Oct 2015
Posts: 16
cwkotch is on a distinguished road
Default 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.
Reply With Quote