Good afternoon all,
I want to set up a conditional format that will highlight a cell 12 months after the displayed date in the cell. Please help! I have stuck on this for quite some time.
Thanks,
cm123
Good afternoon all,
I want to set up a conditional format that will highlight a cell 12 months after the displayed date in the cell. Please help! I have stuck on this for quite some time.
Thanks,
cm123
How about
=TODAY()>EDATE(O1,12)
Change cell in red to match the first cell in your range
If the cell is A1, the formula is
Formula:Please Login or Register to view this content.
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
I like Fluff's better, I always forget about EDATE.
6StringJazzer
Thanks for that & the rep
Thanks so much!!!!!!
You're welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks