Cell colour according to date

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

GarysStudent
Thu Mar 13 05:33:01 CDT 2008

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.
--
Gary''s Student - gsnu200773

Bob
Thu Mar 13 06:00:21 CDT 2008

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)



"Boenerge" <Boenerge@discussions.microsoft.com> wrote in message
news:ED529FE6-680F-473E-98E8-BB729B63F753@microsoft.com...
> 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