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 / Programming / November 2007

Tip: Looking for answers? Try searching our database.

Excel Function Query

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Rodney - 22 Nov 2007 14:25 GMT
Hi everyone,

Somehow i need a formula or something similar which will do the following.
Basically, i have a column (A) of cells with different dates in them (e.g.
11/10/07). I then have another column (B) with some blank cells and some
cells with numerical values in them. What i want to do is make only the blank
cells in column B turn blue if 60 days over the date in Column A passes. For
example, cell A1 contains the following date: 11/07/07 and Cell B1 is blank.
Therefore cell B1 should be blue because 60 days have passed since 11/07/07.

Hopefully someone can help, and that makes sense!

Thanks!
Rod
Nigel - 22 Nov 2007 14:57 GMT
You can use conditional formatting.

Click on cell B1, choose Format from the menu and then choose Conditional
Formatting.

Set condition 1 (left hand drop down) to 'Formula Is' then in the empty box
to the right type in

=AND(A1>0,B1=0,NOW()-A1>60)

Set the Format to Patterns 'Blue'   press OK

Copy this cell and 'Paste Special - Formats' to all relevant cells in column
B

Signature

Regards,
Nigel
nigelnospam@9sw.co.uk

> Hi everyone,
>
[quoted text clipped - 14 lines]
> Thanks!
> Rod
 
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



©2008 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.