Hi There
I am trying change the background color of a cell based on if a number falls between a particular number range. e.g. if the number entered into the cell is between 0-60% the cell color will be red, if it is between 61% and 70% it will be orange and if it is between 71% and 100% it will be green.
Any help with this would be greatly appreciated
Home Tab > Conditional Formatting > New Rule > Use a formula to determine which cells to format.
Rule 1: >0%-<61% =AND($A1>0,$A1<0.61) Colour Red
Rule 2: >=61%-<71% =AND($A1>=0.61,$A1<0.71) Colour Orange
Rule 3: >=71%-<=100% =AND($A1>=0.71,$A1<=1) Colour Green
Last edited by Kevin UK; 09-01-2012 at 09:03 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks