 |
 | 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 / Worksheet Functions / August 2006Date sensitive cell pattern color
Greetings, How can I set up a cell's pattern color to automatically change to red when a certain date arrives? I would hope it could be done without VB as my knowledge is very limited. Thanks for your help. hi, Darrell, try to use conditional format (Fomart | Conditional Format) hth  Signatureregards from Brazil Thanks in advance for your feedback. Marcelo > Greetings, > How can I set up a cell's pattern color to automatically change to red when > a certain date arrives? I would hope it could be done without VB as my > knowledge is very limited. > Thanks for your help. Thanks Marcelo, but how can I enter some future date and when that date comes the cell turns red? I can't find a way to enter the IF and DATE function in the conditional format. ds > hi, Darrell, > [quoted text clipped - 8 lines] >> knowledge is very limited. >> Thanks for your help. 1. Select the cell in question 2. Select Format->Conditional Formatting 3. Select "Formula Is" 4. Enter this formula =TODAY()>=DATEVALUE("8/15/2006") 6. Click Format, and select the pattern you want. 7. Click Ok Replace 8/15/2006 with the date you want to use, but be sure to keep the quotes around the date. If the date is in the cell then use the cell reference in the formula like this... =TODAY()>=A1 or use "Cell Value Is" -> "Less than or equal to" -> =TODAY() Whichever way you choose the cell pattern will change when the current date has reached the date in question. > Greetings, > How can I set up a cell's pattern color to automatically change to red when > a certain date arrives? I would hope it could be done without VB as my > knowledge is very limited. > Thanks for your help. That did it. Thank you very much. ds > 1. Select the cell in question > [quoted text clipped - 27 lines] >> knowledge is very limited. >> Thanks for your help. |
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.