Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want format cells to have expiry dates & highlight
Is there a way in excel that i can put a date in a cell and have it
automatically highlight to show its expiring at a certain time period, whether it be 1 or 2 years later? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want format cells to have expiry dates & highlight
You could try conditional formatting
An example ... Assume A2 contains a real date: 5-May-2008 Assume dates which are = 6 months and < 12 months old are to be formatted in brown fill (1 month is assumed = 30 days) Select A2, click Format Conditional formatting, then apply it in Condition 1 using Formula Is: =AND(A2<"",TODAY()-$A$2=180,TODAY()-$A$2<360) Format Brown fill OK out -- Max Singapore http://savefile.com/projects/236895 Downloads:22,500 Files:370 Subscribers:66 xdemechanik --- "Aims" wrote: Is there a way in excel that i can put a date in a cell and have it automatically highlight to show its expiring at a certain time period, whether it be 1 or 2 years later? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Highlight Specific dates/cells | Excel Discussion (Misc queries) | |||
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 | |||
Cond Format: Expiry Date Alert | Excel Discussion (Misc queries) | |||
automatically highlight cells with expired dates?! | Excel Discussion (Misc queries) |