 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / May 2008Conditional Formatting for Excel 2003
D2 has start date( Goods ordered) 02/06/08 E2 has end date (Due date) 16/06/008 F2 is for order confirmation – either blank or Yes G2 is a date for Goods Received Please help. In F2 or G2 which ever is convenient, I don’t even mind having helper columns. I want Color Formatting based on following criteria: If F2 & G2 are blank & its 7 days before F2, I want to show Brown color for chasing order confirmation. If F2 or G2 are blank from 2 days before due date and until the F2 or G2 are populated, I want to show red colour. I hope this makes sense. Regards, Lee Select F2 and G2, then do Format>Conditional Formatting. You will add two conditional formats: the first one, change the type to "Formula Is" and type this in: =AND(TODAY()-E2<3,F2="",G2="") change the pattern to red then add another conditional format using "Formula Is" and type this in: =AND(TODAY()-E2<8,F2="",G2="") change the pattern to brown  SignaturePlease remember to indicate when the post is answered so others can benefit from it later. > D2 has start date( Goods ordered) 02/06/08 > E2 has end date (Due date) 16/06/008 [quoted text clipped - 17 lines] > > Lee > Select F2 and G2, then do Format>ConditionalFormatting. You will add twoconditionalformats: > the first one, change the type to "Formula Is" and type this in: [quoted text clipped - 30 lines] > > - Show quoted text - Thank you very much. It did work. Sorry for the delay in replying. I wanted to check it on Excel 2003, which I only have at work. Now, how can I filter these cells according to colour in excel 2003. Regards, Lee Check out Chip Pearson's site for tips on sorting by color: http://www.cpearson.com/excel/sortbycolor.htm SignaturePlease remember to indicate when the post is answered so others can benefit from it later. > > Select F2 and G2, then do Format>ConditionalFormatting. You will add twoconditionalformats: > > the first one, change the type to "Formula Is" and type this in: [quoted text clipped - 37 lines] > Regards, > Lee |
Reply to this Message |
 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.