Cell colour according to date

  • Thread starter Thread starter Boenerge
  • Start date Start date
B

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
 
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.
 
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)
 
Back
Top