I work in supermarket retail and have to report on scheduling metrics. I show on a separate chart how many weeks in a row a store missed scheduling goals by coloring the store a certain color that represents the number of weeks. Right now I color each store cell manually.

I’m looking for a formula to color in the store certain colors based on how many weeks in a row they missed the metric goal. Example, store 473 missed meeting 65% 4 weeks in a row out of 6 weeks. I want store 473 to be automatically colored orange instead of manually coloring in orange. Store 70 missed meeting 65% 2 weeks in a row out of 6 weeks, I want to color that store gray.

Any help will be appreciated!

​I work in supermarket retail and have to report on scheduling metrics. I show on a separate chart how many weeks in a row a store missed scheduling goals by coloring the store a certain color that represents the number of weeks. Right now I color each store cell manually.I’m looking for a formula to color in the store certain colors based on how many weeks in a row they missed the metric goal. Example, store 473 missed meeting 65% 4 weeks in a row out of 6 weeks. I want store 473 to be automatically colored orange instead of manually coloring in orange. Store 70 missed meeting 65% 2 weeks in a row out of 6 weeks, I want to color that store gray. Any help will be appreciated!  Read More

​