Cell colour according to date

[Boenerge]

Hi,
Is there a formula that would change the cell colour if a date in a cell was
out of date afetr a set number of years.
Example:
Cell B9 contained date 140506
I then want the cell B9 to turn red when the date reaches 2 years later
140508.
Thanks in advance
Jason

 

[Gary''s Student]

Let's assume that your example date is 14 May 2006.

Click on B9 and:

Format > Conditional Formatting... > Formula Is > =TODAY()-B9>731
then pick the colour red.

 

[Bob Phillips]

Use conditional formatting with a formula of

=DATE(YEAR(B9)+2,MONTH(B9),DAY(B9))<TODAY()

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)