Date Counting

[alivy206]

Hi,

I need to be able to keep track of dates easily. I would like to put a date into a cell, highlight that cell one color. Then 90 days from that date, have that cell change to a different color. Or have excel in some way count 90 days from one date and tell me, rather than going to a calendar and counting myself.

Thanks for the help! Happy Holidays

[Don]

Hi and welcome to the forum!

You can use conditional formatting for this.

Select the cell you want to change colors, go to conditional formatting (in excel 2007 and later its on the Home Tab in the Styles box). Then, click New Rule and go to where it allows you to enter a formula (something like "Use a formula..." and enter this formula:

Code: Select all

=TODAY()>=(A1+90)

Chnage A1 to the cell that contains the date.

hope this helps