Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formatting expiry dates
Hi All,
I am trying to conditional format a spreadsheet that i have licence expiry dates but want to flag these 30 days prior to expiry but also want the actual expiry date to also highlight if it has gone over the 30 days, i seem to be able to get the dates correct but they are staying highlighted, any suggestions?? Eg B2 is 30 earlier than C2, really just unsure of the formula to use. Thanks in advance. -- mooty |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formatting expiry dates
"30 earlier than C2" is:
=c2-30 It's unclear what you mean by "30 days prior to expiry". I expect you mean once it's within the period 30 days before expiration. If so, try: =b2c2-30 Regards, Fred. "mooty" wrote in message ... Hi All, I am trying to conditional format a spreadsheet that i have licence expiry dates but want to flag these 30 days prior to expiry but also want the actual expiry date to also highlight if it has gone over the 30 days, i seem to be able to get the dates correct but they are staying highlighted, any suggestions?? Eg B2 is 30 earlier than C2, really just unsure of the formula to use. Thanks in advance. -- mooty |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I set up a sheet for reagents that will flag expiry dates? | Excel Discussion (Misc queries) | |||
I want format cells to have expiry dates & highlight | Excel Worksheet Functions | |||
how to monitor/highlight upcoming expiry/due dates | Excel Discussion (Misc queries) | |||
Check dates in spreadsheet against expiry years column and change colour | Excel Worksheet Functions | |||
Conditional Formatting for dates | Excel Worksheet Functions |