Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need your suggestions
Hi everyone, I have a sheet detailing orders. One of the column is having expiry date of L/C (well LC means Letter of credit its a payment instrument) in case Lc expires before the shipment of order the L/c has either to be extended or the order has to be cancelled. Recently I have added this column in my sheet because its important to get notified if L/C expiry date is near. Since the sheet is too large, putting expiry date in front of each order won't help me enough, so what i want is to get notified if one or more L/Cs are going to be expired in next 15 days. Kindly propose what sort of solution suits this situation best. -- irresistible007 ------------------------------------------------------------------------ irresistible007's Profile: http://www.hightechtalks.com/m63 View this thread: http://www.hightechtalks.com/t2308883 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need your suggestions
One play is to use conditional formatting (CF) to colour the entire row
for LCs' with expiry dates within the next 15 days Assuming the "Expiry of LC" col is col C, dates in row2 down Select row2 to say, row100 (with A2 active) Put as the CF formula: =AND($C2<=TODAY()+15,$C2<"") Format to taste OK out Lines with expiry dates in col C which are <= the next 15 days will be conditionally formatted -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "irresistible007" wrote in message ... Hi everyone, I have a sheet detailing orders. One of the column is having expiry date of L/C (well LC means Letter of credit its a payment instrument) in case Lc expires before the shipment of order the L/c has either to be extended or the order has to be cancelled. Recently I have added this column in my sheet because its important to get notified if L/C expiry date is near. Since the sheet is too large, putting expiry date in front of each order won't help me enough, so what i want is to get notified if one or more L/Cs are going to be expired in next 15 days. Kindly propose what sort of solution suits this situation best. -- irresistible007 ------------------------------------------------------------------------ irresistible007's Profile: http://www.hightechtalks.com/m63 View this thread: http://www.hightechtalks.com/t2308883 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trying to match a text string to a data table, any suggestions? | Excel Worksheet Functions | |||
Suggestions on possible chart | Charts and Charting in Excel | |||
Printing is slow: Any suggestions | Excel Discussion (Misc queries) | |||
Suggestions for creating Issues Log using Excel? | Excel Worksheet Functions | |||
Looking for Someone to review and make suggestions | Excel Discussion (Misc queries) |