A anoopbal New Member Dec 6, 2010 #1 How do you highlight the coloumn when the date is Today in the top date row. This is for a daily task list. This way I can see what day is today. I can highlight the cell when the date is today with conditional formatting. But cannot get the column of the cell to highlight.
How do you highlight the coloumn when the date is Today in the top date row. This is for a daily task list. This way I can see what day is today. I can highlight the cell when the date is today with conditional formatting. But cannot get the column of the cell to highlight.
Hui Excel Ninja Staff member Dec 6, 2010 #3 Select all the Columns eg: D:M Goto Conditional Formatting New Rule, Use a Formula Formula: =D$1=Today() Set Format Apply
Select all the Columns eg: D:M Goto Conditional Formatting New Rule, Use a Formula Formula: =D$1=Today() Set Format Apply
K keymaster New Member Dec 6, 2010 #4 Also refer to conditional formatting on dates here: http://chandoo.org/wp/2010/01/05/conditional-formatting-dates/ to know how to highlight other types of dates...
Also refer to conditional formatting on dates here: http://chandoo.org/wp/2010/01/05/conditional-formatting-dates/ to know how to highlight other types of dates...
A anoopbal New Member Dec 6, 2010 #5 Cool. Thanks . That was easy! I got no clue how that dollar sign works.
Hui Excel Ninja Staff member Dec 6, 2010 #6 The Dollar sign says only look at Row 1 so for D50 it is looking at Cell D1 and comparing the date If you didn't have the $ sign D50 would look at D50 and not have a date and so not be conditionally formatted
The Dollar sign says only look at Row 1 so for D50 it is looking at Cell D1 and comparing the date If you didn't have the $ sign D50 would look at D50 and not have a date and so not be conditionally formatted
A anoopbal New Member Dec 8, 2010 #7 Thanks!! What if i want to highlight the weekends too ( sat & sun)?
