I am working on a spreadsheet and want to use conditional formatting. I want to use a green, yellow, red color scale, so I am selecting the more rules option under the color scale and changing it to a three color scale. That option actually does the opposite, and starts with red first. The rule type I am using is to format all cells based on their values. I'm guessing that I then want to change the type option to number, as shown in the screenshot.
What I want to do is have the cell be green if the value is less than or equal to 129. If it's 130-149, I want the cell to be yellow. If it's more than 150, I want to be red. I'm not sure of the formulas to create in order to accomplish this.
Question
cbrookhart
I am working on a spreadsheet and want to use conditional formatting. I want to use a green, yellow, red color scale, so I am selecting the more rules option under the color scale and changing it to a three color scale. That option actually does the opposite, and starts with red first. The rule type I am using is to format all cells based on their values. I'm guessing that I then want to change the type option to number, as shown in the screenshot.
What I want to do is have the cell be green if the value is less than or equal to 129. If it's 130-149, I want the cell to be yellow. If it's more than 150, I want to be red. I'm not sure of the formulas to create in order to accomplish this.
Link to comment
Share on other sites
2 answers to this question
Recommended Posts