View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Colby Africa Colby Africa is offline
external usenet poster
 
Posts: 17
Default How do I set up Alerts and Notification on Excel?

Hello,

One approach is to use conditional formatting (using formulas instead
of values) such that all expiration dates approaching within your 2-3
month range are color-coded in some way.

There is a good article here on the subject:

http://www.cpearson.com/excel/cformatting.htm

Colby Africa
http://colbyafrica.blogspot.com