Date Formula & Alerts

[Kidtick7609]

I am creating a excel spreadsheet that contains expiration dates of contracts. Is there a way to have the excel alert me before the date arrives or maybe just change color to let me know the end date is coming up? I would like to have an alert 2 months prior to the expiration. Any help would be greatly appreciated. I'm a fairly new user of excel 2003.

Thanks!

[daddylonglegs]

If the expiration date is in B2 then to highlight B2 when less than 60 days away, select B2 and use

Format > Conditional Formatting > "formula is"

=AND(B2<>"",B2-TODAY()<60)

select required formatting

[Kidtick7609]

Thank you so much. It works. I have been trying to do this for weeks. I was thinking it could only be an if,then formula.

[Sigil82]

I could use a bit more help with this myself...I used the first formula and it works great but I want to expand on it a bit. I'm tracking medical supplies and they all have exp. dates. I want to have different format changes based upon whether the item(s) are expired or exipiring within a few months of the date. Thanks in advance.