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

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 he

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

On Feb 14, 12:23*am, day wrote:
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...

Nowaday, I use Excel version 2003.