conditional formatting overdue dates

J

Joooooooo

Hi
In my excel sheet I have a column (M7:M25) of dates when reviews have taken
place. I want to format it so that the dates that are more than a year old
are highlighted.. Any ideas? Thanks in advance :)
 
A

Akhilesh Dalia

Hi,

In cell type =IF((TODAY()-M7)>365, "Overdue", "Current"), and then press
ENTER.

Regards

Akhilesh Dalia
akhileshdalia<at>hotmail<dot>com
 
Top