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...
|