Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Reminder | Excel Discussion (Misc queries) | |||
pop up box reminder | Excel Discussion (Misc queries) | |||
Reminder in excel | Excel Discussion (Misc queries) | |||
Conditional Summing reminder/refresher (please!) | Excel Worksheet Functions | |||
Pop-Up Reminder | Excel Discussion (Misc queries) |