| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional format when date is near
That did the trick, thankyou!
"Martin Fishlock" wrote: Tom, Use conditional formating with the formula is =$E$4-NOW()<=7 and then set the pattern, then add another =$E$4-NOW()<=21 and then set the pattern -- Hope this helps Martin Fishlock Please do not forget to rate this reply. "tommcbrny" wrote: Hello, I would like to format a "Status" cell to red, amber, or green depending on how far a date entry in an "Estimated Date" cell is from the actual date (ie today's date). For instance, if the estimated date is 3 weeks or more in the future from today, the status is green. If less than 3 weeks, but more than 1 week in the future, amber. If less than 1 week in the future, red. Is something like this possible? Thank you, Tom |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert a month to a quarter ...... | New Users to Excel | |||
| Excel 2007 Date Format Problem | Excel Discussion (Misc queries) | |||
| Conditional format won't copy | Excel Discussion (Misc queries) | |||
| Date Format Problems?? | Excel Discussion (Misc queries) | |||
| Office2000: Conditional format behaves strangely | Excel Discussion (Misc queries) | |||
Threaded Mode
