conditional Reminder

[day]

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

 

[Pete_UK]

Blinking text is not a standard feature in Excel, and there are good
reasons to avoid it. However, if you must, then have a look here:

http://www.cpearson.com/excel/BlinkingText.aspx

In versions of Excel before 2007 there is a limit of 3 conditional
formats per cell, so unless you are using the latest version you won't
be able to set up all the conditions you want.

Hope this helps.

Pete

 

[day]

Nowaday, I use Excel version 2003.