#1
|
|||
|
|||
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. |
#2
|
||||
|
||||
Select the entire range (rows and columns) and use =$A1=today() as CF. Format as required
As you did not post a sample sheet, unable to see if dates are real dates or text looking like dates
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
wooksheet example
Just a sample of the sheet as the dates/days extend to 12/31/2022...would like the rows to highlight the date for the current dats and extend the formatting to column atleast column G, and possibly further in the future
|
#4
|
||||
|
||||
Have you tried my suggestion??
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#5
|
|||
|
|||
I have yes. Only current date highlighted. I’m looking to see if the entire row after the date column and up to the last named column would highlight
|
#6
|
||||
|
||||
I don't think you followed the instructions correctly. You have the select columns AND rows, and of course adapt the formula to your data.
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#7
|
|||
|
|||
Yup, I did follow correctly. still it only highlighted the cell containing todays date
|
#8
|
||||
|
||||
If you still have a problem, please post your sheet so we can see what is wrong. thx
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#9
|
|||
|
|||
Quote:
2. When you write the formula, follow Pecoflyer's example [=$A1=today()] in that the dollar sign is only on the column, not the row. So, no matter which column you're applying the conditional formatting in, it's based on the condition of the date in column A (the dollar sign makes that absolute) but relevant to each row separately (row not absolute bur relative.) |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Save as PDF in specific location with filename using todays date | miyoung | Word VBA | 2 | 08-15-2017 09:15 AM |
I need help creating a conditional format | tonydoneese | Excel | 5 | 05-28-2017 10:42 AM |
Highlight row based on todays date problem | manxman79 | Excel | 6 | 11-17-2014 09:06 AM |
How does this Conditional Format work? | Gary Drumm | Excel | 7 | 04-16-2014 12:01 PM |
Conditional Format cell appearance Excel 2007 | Gary Drumm | Excel | 3 | 02-22-2014 01:43 AM |