software

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: www.hightechtalks.com/m63
View this thread: www.hightechtalks.com/t2308883One play is to use conditional formatting (CF) to colour the entire row
for LCs' with expiry dates within the next 15 days

Assuming the quot;Expiry of LCquot; col is col C, dates in row2 down
Select row2 to say, row100 (with A2 active)
Put as the CF formula: =AND($C2lt;=TODAY() 15,$C2lt;gt;quot;quot;)
Format to taste gt; OK out

Lines with expiry dates in col C which are lt;= the next 15 days
will be conditionally formatted
--
Rgds
Max
xl 97
---
Singapore, GMT 8
xdemechanik
savefile.com/projects/236895
--
quot;irresistible007quot; gt;
wrote in message
...
gt;
gt; Hi everyone,
gt;
gt; I have a sheet detailing orders. One of the column is having expiry
gt; date of L/C (well LC means Letter of credit its a payment instrument)
gt; in case Lc expires before the shipment of order the L/c has either to
gt; be extended or the order has to be cancelled.
gt;
gt; Recently I have added this column in my sheet because its important to
gt; get notified if L/C expiry date is near. Since the sheet is too large,
gt; putting expiry date in front of each order won't help me enough, so
gt; what i want is to get notified if one or more L/Cs are going to be
gt; expired in next 15 days.
gt;
gt; Kindly propose what sort of solution suits this situation best.
gt;
gt;
gt; --
gt; irresistible007
gt;
gt;
gt; ------------------------------------------------------------------------
gt; irresistible007's Profile: www.hightechtalks.com/m63
gt; View this thread: www.hightechtalks.com/t2308883
gt;