Jump to content



Photo

Excel 2007 Conditional Formatting Help

Answered Go to the full post excel 2007

  • Please log in to reply
2 replies to this topic

#1 cbrookhart

cbrookhart

    Neowinian

  • Joined: 07-February 06
  • Location: Miramar, FL

Posted 02 January 2014 - 23:37

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.

 

excel.jpg



Best Answer Jeston , 03 January 2014 - 00:06

I'm no Excel guru, but I would just use 3 separate rules as shown below:
 
TSlGX9B.png
 
f0rGJnd.png

 

The reason I used a "2-Color Scale" for 0-129 is because if I do it the same as the other two, all blank cells default to green as well. If you're not applying this rule to cells that are empty, the rule can be changed to the same as the yellow rule except obviously you would change the values to from 0-129.

 

Again, there may be an easier way to do it, but this is how I would do it.

 

Edit: I'm also assuming you didn't want the colors to gradually change from green -> yellow -> red depending on their values, but rather wanted one solid color for each of those value ranges.

Go to the full post



#2 Jeston

Jeston

    Neowinian Senior

  • Tech Issues Solved: 4
  • Joined: 07-July 05
  • Location: Las Cruces, NM, US

Posted 03 January 2014 - 00:06   Best Answer

I'm no Excel guru, but I would just use 3 separate rules as shown below:
 
TSlGX9B.png
 
f0rGJnd.png

 

The reason I used a "2-Color Scale" for 0-129 is because if I do it the same as the other two, all blank cells default to green as well. If you're not applying this rule to cells that are empty, the rule can be changed to the same as the yellow rule except obviously you would change the values to from 0-129.

 

Again, there may be an easier way to do it, but this is how I would do it.

 

Edit: I'm also assuming you didn't want the colors to gradually change from green -> yellow -> red depending on their values, but rather wanted one solid color for each of those value ranges.



#3 OP cbrookhart

cbrookhart

    Neowinian

  • Joined: 07-February 06
  • Location: Miramar, FL

Posted 03 January 2014 - 01:18

I was thinking that I needed to create formulas to accomplish what I was trying to do, but the three separate formatting rules seems to have worked.

 

Thanks.





Click here to login or here to register to remove this ad, it's free!