Forum Discussion
Conditional Formatting for Dates in Excel
Hi - I'm trying to create a formula that will change the color of a cell based on a date in 2 and 4 week intervals. I want to be able to enter in a date (which would start green) and then 2 week...
Is the attached file the sort of thing you need?
If not can you post a sample file?
Wyn Hopkins Ok, so I've got it to do what I want it to do, but I want the rental date to start out as green, then the column that says 2 weeks to change to yellow when it reaches 2 weeks, and the column that says 4 weeks to change to red when it reaches 4 weeks. Right now, only the current date changes colors. If that makes sense I hope?
Thanks!Amy
Hi Amy
Is the attached what you are after?
Actually it looks right, but when I change the Rental Date, the yellow and red colors change back to black.
Amy
Hi Amy
Is the attached what you are after?
