Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Past date in column to change color
I'd like to have my excel sheet columns with the dates to change to a
specific color as the date pass's. I've racked my brain thinking of how. Anyone?? |
#2
|
|||
|
|||
Hi Cris
You can use CF http://www.contextures.com/xlCondFormat01.html Post back if you need more help -- Regards Ron de Bruin http://www.rondebruin.nl "Chris" wrote in message ... I'd like to have my excel sheet columns with the dates to change to a specific color as the date pass's. I've racked my brain thinking of how. Anyone?? |
#3
|
|||
|
|||
Format Conditional Formatting
Then assign colors based on criteria you define, say, greater than Date+30, then format color as green (or whatever you wish). Be aware you can only use three conditional formats per cell. HTH, Kevin McClement MOS Excel Specialist "Chris" wrote: I'd like to have my excel sheet columns with the dates to change to a specific color as the date pass's. I've racked my brain thinking of how. Anyone?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change the color of my row and column headers? | Excel Discussion (Misc queries) | |||
Auto Skipping and protected cells | Excel Discussion (Misc queries) | |||
HOW TO USE A FORMULA TO CHANGE CELL COLOR ACCORDING TO DATE RANGE. | Excel Worksheet Functions | |||
Change the width of a single column in a column chart | Charts and Charting in Excel | |||
Identifying the Active Fill Color | Excel Discussion (Misc queries) |