| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Colors Dependant on Date
If I were to assign "=NOW()" to say...cell A10 and have column C dedicated to delivery dates for customers, could I have the cells automatically change colors the closer it gets the date in cell A10? For instance: If any of the delivery dates were 2 weeks away then the cells would turn green, 1 week away those cells would turn limegreen, 3 days away they would turn yellow and past due would be red. Thnx for any help -- RJM ------------------------------------------------------------------------ RJM's Profile: http://www.excelforum.com/member.php...o&userid=24822 View this thread: http://www.excelforum.com/showthread...hreadid=551179 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| date in Cell to change colors if the date is beyond today's date | Excel Discussion (Misc queries) | |||
| Automatically change cell colors based on date in cell | Excel Discussion (Misc queries) | |||
| Can a cell change colors when the date entered arrives? | Excel Discussion (Misc queries) | |||
| Cell colors or text color changing when date in cell gets closer. | Excel Worksheet Functions | |||
| Date dependant values. | Excel Discussion (Misc queries) | |||
![RJM[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
