Change row color based on a date in one cell

[capncaveman]

What I would like to do is have a spreadsheet with our online orders and keep track of when the orders go beyond a certain date.

For instance. I have all the order information on one row. One of these cells will be an order date. I would like to have that whole row green within one week of the order date and then turn yellow from 1 week to 2 weeks and turn red beyond 2 weeks from the order date. The order dates will always be different so the formula will have to go off of the order date...not the current date.

I would also like to have a cell with a check box or a cell where I can enter "Shipped" and it will then turn the row back to white.

Is this possible? I am using Excel 2007

Any help would be appreciated!!

 

[repairman615]

Hello Glenn,


I do think Conditional Formating would be much easier and even more appropriate.

I overlooked that and made things a bit more complicated.
I checked the spark plug before I checked the fuel...

I did rather enjoy writting the code though.

-Jeff