conditional formatting overdue dates

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

Hi,

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

Regards

Akhilesh Dalia
akhileshdalia<at>hotmail<dot>com

"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

As the range of your example is only a few rows, try this:

a) Create a temporary column just next to the column where the dates are located
b) Use the formula =DATEDIF(M7;NOW();"y")
c) Sort your worksheet by the column of the DateDif function
d) Highlight the dates where on the next columns the DATEDIF function returs values from 1 and above

Hope you find it usefull

Regurds

The simplest way is using conditional formatting.

for a date in cell A1

highlight the cell and select Format, Conditonal Formatting

Set condition 1 to "formula is" then enter the condition =today()-A1>365
then set your format

Copy the format down the column and hey presto!