Conditional formatting problem

[andrewb90]

I have a list of food products on several sheets. In one column are all of the expiration dates. I have conditional formatting to change the cell color to a different color depending on if its expiring this month, next week, this week, or in the last 7 days. Now after a product has been expired for 7 days, the color will change again to yellow. which is the color of items expiring in the month. I dont want it to change again, after the 7 days of being dark red, I would like it to go back to white. The colors I am using are yellow, orange, red and dark red. For this month, next week, this week, and last seven days respectively. Can anybody help me out with this?

Andrew

 

[texasalynn]

How are you doing the conditional formatting? through VBA? Post sample of conditions you are using