Hope someone can help with this, before I lose the rest of my hair!
Using Excel 2007
Cell F20 contains ='book 3'!C11
The cell is is formatted as a date and simply reads the date from the other sheet.
I want to make cell F20 turn red if the date is over 30 days ago.
Sounds simple for conditional formatting, but I just can't make it work. There must be a simple way to make the cell turn red if the date goes over 30 days.
Help please!!
TIA
Bookmarks