Hey all,
I have been trying to figure out how to use conditional formating to highlight a cell if the date in the cell is over 160 days ago.
For example:
Class was taken on 15 August 2012 (cell C4R5)
Today is 20 March 2013 (more than 160 days)
I want the date that the class was taken (C4R5) to be filled with red.
At work I am using Office 2007. Thanks for any and all help
Using a formula in conditional formatting:
=TODAY()-C4R5>160
Note, I don't use CR format, so I would change C4R5 to D5.
Pauley
--------
If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).
That works like a charm. I was using =>Date()-160. I have a fair amount to learn about excel. Thanks again
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks