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?? |
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?? |
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?? |
All times are GMT +1. The time now is 12:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com