How do I set up excel to let me know when a date has expired?

  • Thread starter Thread starter UB
  • Start date Start date
U

UB

I am trying to set up excel where it will notify me when a perticular date
that I have entered has expired. Such as an insurance policy which is going
to expire at a set time. I believe you can set this up in Excel where excel
will change the color of the cell to reflect this.
 
UB said:
I am trying to set up excel where it will notify me when a perticular date
that I have entered has expired. Such as an insurance policy which is going
to expire at a set time. I believe you can set this up in Excel where excel
will change the color of the cell to reflect this.
Click to expand...

You have two options, conditional formatting or create another column and
use an if statement

Depending on the version of Excel you're running, will determine how you
implement the conditional formatting, 2007 has a built-in date conditional
formatting, previous versions would require you to 'calculate' it.

HTH
 
Back
Top