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

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.
 
R

RyanR

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.

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top