Conditional Formatting-Highlight entire column with today's date.
I have a list of data on a spreadsheet that I need some help using the conditional format...
I would like to highlight the entire column that is in the same column as today's date. So if I open it 2 days from now then that day's column would be highlighted.
Can someone please help?
Re: Conditional Formatting-Highlight entire column with today's date.
OK, to make this easier...
In C2, enter 1/1/13, then fill that right to BK2.
If you just want the actual day number to appear as in your example, then apply a Custom date format to those cells (C2:BK2): "d" without the quotes.
Then, select cells C2:BK26, and click on Conditional Formatting, and use this formula:
Select the color you want today's column to be highlighted, and click OK.
Last edited by Moo the Dog; 01-24-2013 at 05:04 PM.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1