| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date sensitive cell pattern color
That did it. Thank you very much.
ds "Sloth" wrote in message ... 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. "Darrell Shuman" wrote: 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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reference Cell Color From Other WorkSheets | Excel Worksheet Functions | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Changing Cell formats to date fields automatically | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
