By Alpha_Tay · Posted
By wrack · Posted
By +virtorio · Posted
By Nick H. · Posted
By ad47uk · Posted
We rely on ads to keep creating quality content for you to enjoy for free.
Please support our site by disabling your ad blocker.
Continue without supporting us
If the prompt is still appearing, please disable any tools or services you are using that block internet ads (e.g. DNS Servers, tracking protection or privacy extensions).
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
https://www.neowin.net/forum/topic/1195099-excel-2007-conditional-formatting-help/Share on other sites
2 answers to this question
Recommended Posts