I am trying to conditionally format cells in a given row where the criteria value will increase by a set amount each week.

For instance: over a 13 week period (1 qtr) we set a goal of selling $50 a week. So the goal is $150 by week 3. Each week the dollars sold is reported. Week 1 - 50, week 2 - 35, week 3 - 45.

I want to conditionally format the cells so the background will turn green or red dependent on if the YTD meets the goal for that week. The goal cell will change each week and a new cell will be added for the new week. But i don't want the other cells to change color after the goal changes.

Hopefully I haven't confused everyone but your help is appreciated. I think this may be hopeless. We use this for a scorecard with other metrics on a weekly basis.

Thanks!

joe