Hi,

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

Regards

Akhilesh Dalia
akhileshdalia<athotmail<dotcom

"Joooooooo" wrote:

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 :)