Hello, I would like the cells on my sheet to change color when the values reach defined thresholds. There are 14 defined thresholds and each one requires a unique color when the value is reached. The values are a running total with a new cell for each month that represent equipment "hours". They increase monthly and the thresholds are scheduled maintenance. The hours can remain in any defined threshold for several months, but when the next threshold is reached, I would like the color to change. This will Trigger a maintenance call.
The colors are just a sample and really don't matter as long as each threshold is a different color:
Threshold #1 = 0 to 499 = N/A or White
Threshold #2 = 500 to 749 = Purple
Threshold #3 = 750 to 999 = Blue
Threshold #4 = 1000 to 1249 = Green
Threshold #5 = 1250 to 1499 = Yellow
Threshold #6 = 1500 to 1749 = Orange
Threshold #7 = 1750 to 1999 = Beige
Threshold #8 = 2000 to 2249 = Grey
Threshold #9 = 2250 to 2499 = Pink
Threshold #10 = 2500 to 2749 = Light Purple
Threshold #11 = 2750 to 2999 = Light Blue
Threshold #12 = 3000 to 3249 = Baby Blue
Threshold #13 = 3250 to 3499 = Military Green
Threshold #14 = 3500 and up = Aqua
I am perplexed and I certainly appreciate any assistance.
Thank you in advance.
The colors are just a sample and really don't matter as long as each threshold is a different color:
Threshold #1 = 0 to 499 = N/A or White
Threshold #2 = 500 to 749 = Purple
Threshold #3 = 750 to 999 = Blue
Threshold #4 = 1000 to 1249 = Green
Threshold #5 = 1250 to 1499 = Yellow
Threshold #6 = 1500 to 1749 = Orange
Threshold #7 = 1750 to 1999 = Beige
Threshold #8 = 2000 to 2249 = Grey
Threshold #9 = 2250 to 2499 = Pink
Threshold #10 = 2500 to 2749 = Light Purple
Threshold #11 = 2750 to 2999 = Light Blue
Threshold #12 = 3000 to 3249 = Baby Blue
Threshold #13 = 3250 to 3499 = Military Green
Threshold #14 = 3500 and up = Aqua
I am perplexed and I certainly appreciate any assistance.
Thank you in advance.