View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
day day is offline
external usenet poster
 
Posts: 4
Default conditional Reminder

Need Help!!!

In A1, I have Permit Expiry date (eg. 1/12/2009), and than
In B1, I want to make reminder cell with conditions:

If TODAY, permit expiry more than a year == Cell will have GREEN shading
color and word "Secure";

If TODAY, permit expiry between a year to 6 month == Cell will have
blinking YELLOW shading and word "1 Year Reminder";

If TODAY, permit expiry between 6 month to 3 month == Cell will have
blinking ORANGE shading and word "6 Month Reminder";

If TODAY, permit expiry between 3 month to 1 month == Cell will have
blinking RED shading and word "3 Month Reminder";

If TODAY, permit expiry less than or equal a month == Cell will have
blinking DARK RED shading and word "1 Month Reminder";

If TODAY, permit was expiry == Cell will have blinking DARK GREY shading
and word "EXPIRED";

Please help me, I almost despreate thinking about this one...