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?
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:
=C$2=TODAY()
Select the color you want today's column to be highlighted, and click OK.
- Moo
Last edited by Moo the Dog; 01-24-2013 at 05:04 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks