Setting notification of dates in Excel

[Guest]

How do I setup a notification that a date of expiration is 2 months away in a
spreadsheet. I want the spreadsheet to automatically highlight if the person
is about to expire with a qualification date. Is this possible and how do I
achieve this goal?

Thanks for any help!

 

[daddylonglegs]

If you have a date in C10, for instance you can select that cell and
use

Format > Conditional Formatting > Condition 1 > Formula is

=(C10<TODAY()+60)*(C10>TODAY())

select desired formatting

The date will now be formatted accordingly if it's between today and 60
days time

 

[Guest]

You can use conditional formatting to set a red background, for example, if a
condition is met. Suppose you'd like to highlight columns 1 through 20 of
any row where column B of that row is within 60 days. If the first row to
consider is row 2, then in A2: Format > Conditional Formatting. Choose
'Formula Is' from the first dropdown, and enter the formula
=($B1-date()<=60). Click the Format button, then the Patterns tab, then the
color you'd like, then OK twice. (If the expiration date is in a different
column, adjust the cell reference in the formula above). You can copy the
format throughout your table (copy / edit paste special, formats; or use the
format painter).
--Bruce