I am struggling trying to find the proper way to set this up, yet it seems like it should be so easy.
Let's say I have a set of data. The data can be just about any number, but I want to put the low range in red, the middle range in yellow and the top range in green.
For the top 35%, they would be green
For the middle 30%, they would be yellow
For the bottom 35%, they would be red.
For example:
if my Data set is: 1, 25, 45, 51, 80, 100
1 (would turn this cell red)
25(would turn this cell red)
45(would turn this cell yellow)
51(would turn this cell yellow)
80(would turn this cell green)
100(would turn this cell green)
I see where I can put above average, below average, or to set a specific range.
But is there a way to select the above without having to set 3 rules? i tried looking at stuff here and on Google, but could not find what I was looking for.
How do I set it so that a range of numbers can be put into the colors I am looking for?
I hope I explained that well enough.
Thanks
Let's say I have a set of data. The data can be just about any number, but I want to put the low range in red, the middle range in yellow and the top range in green.
For the top 35%, they would be green
For the middle 30%, they would be yellow
For the bottom 35%, they would be red.
For example:
if my Data set is: 1, 25, 45, 51, 80, 100
1 (would turn this cell red)
25(would turn this cell red)
45(would turn this cell yellow)
51(would turn this cell yellow)
80(would turn this cell green)
100(would turn this cell green)
I see where I can put above average, below average, or to set a specific range.
But is there a way to select the above without having to set 3 rules? i tried looking at stuff here and on Google, but could not find what I was looking for.
How do I set it so that a range of numbers can be put into the colors I am looking for?
I hope I explained that well enough.
Thanks