Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / December 2005

Tip: Looking for answers? Try searching our database.

Need your suggestions

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
irresistible007 - 14 Dec 2005 07:37 GMT
Hi everyone,

I have a sheet detailing orders. One of the column is having expir
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 t
be extended or the order has to be cancelled.

Recently I have added this column in my sheet because its important t
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, s
what i want is to get notified if one or more L/Cs are going to b
expired in next 15 days.

Kindly propose what sort of solution suits this situation best

--
irresistible00
Max - 14 Dec 2005 08:31 GMT
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
--

> Hi everyone,
>
[quoted text clipped - 17 lines]
> irresistible007's Profile: http://www.hightechtalks.com/m63
> View this thread: http://www.hightechtalks.com/t2308883
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.