| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Input Color Scheme for Date Column
I have a column in Excel that has only dates inputed. I would like to wright
a macro that would look at the dates and do the following: If the date is older than 30 days from the current date then make the active cell color Red If the date is greater than the current date then make the active cell green Thanks Frank |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom color scheme | Excel Discussion (Misc queries) | |||
| Excel color scheme | Excel Discussion (Misc queries) | |||
| custom color scheme for 3d surface map | Charts and Charting in Excel | |||
| Default Color Scheme | Excel Discussion (Misc queries) | |||
| Color Scheme Trouble | Excel Programming | |||
Threaded Mode
