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!

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)*(C10TODAY())

select desired formatting

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


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=508477

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

"Needing help in Guam" wrote:

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!