Does'nt seem to work is the formula correct if this would work it would be
perfect

"Jacob Skaria" wrote:

You can use conditional formatting to highlight the dates about to expire in
one color (say Orange) and dates expired in another (say Red)

1. Select the column with dates (say Column D). Please note that D1 which is
mentioned in this formula is the first cell of the selection.

2. From menu FormatConditional Formatting

3. For Condition1Select 'Formula Is' and enter the below formula
=AND(D1-TODAY()0,D1-TODAY()<5)
Click Format ButtonPattern and select your color (say Orange)

4. Click on Add button.

5. For Condition2Select 'Formula Is' and enter the below formula
=AND(D10,D1-TODAY()<=0)
Click Format ButtonPattern and select your color (say Red)

6. Hit OK

If this post helps click Yes
---------------
Jacob Skaria


"Geo" wrote:

Is there a way to have a message box pop up to warn of a date about to expire
and to warn when expired too?