Date Conditional Formatting

[SALTECH]

Hi Guys,

Basically what I am after is a basic table with name/company/Serial/Date.

What I need is a format by where every date I enter on that particular day is to expire and be highlighted after 1 year.

So if I put today's date that the contractor had completed a site induction, which is valid for a year, he then came back for example just over a years time he would then be highlighted and need to re-do the induction.

Also, how would I color code dates that are valid (within a year)?

Thanks for your time guys.

Sal

[Fotis1991]

Hi

This formula gives you, what you need.

Use it, in Conditional Format, rules

=DATE(YEAR(A1)+1.MONTH(A1),DAY(A1))  

[Richard Buttrey]

Hi,
Conditional format in A1 - change reference as appropriate

=TODAY()>DATE(YEAR(A1)+1,MONTH(A1),DAY(A1))

format A1 with whatever format you want to see.

[SALTECH]

Thanks guys - I suppose I should have asked for the newbie explanation! I'm terrible at this!

So basically I would highlight the column with the dates in it and then click Conditional formatting, then click new rule. After that which option am I looking to get in

[Fotis1991]

Take a look to the example....

See the Conditional Formatting rules..