Forum Discussion
Color scales and formulas
If I input a test result say 375. In the box below is it possible to set a limit 300-700 green, 200-300 yellow, 0-200 red, 700-800 yellow and 800-infinity red? Depending on my test results that I input would the colors change automatically to the limits.
1 Reply
Dear Jeffery,
Yes you can set the value based on your color scale.. you can use the condition formatting and place the below formula.
1. Select the cell you want the formatting - >Select conditional formatting
2. New Rule
3. Use formula to determine which cell to format cell
4. place this formula =AND(InputCellvalue>200,InputCellvalue<300)
5. Select the color you like by selecting format
6. Select OK..
do the steps till you based on number of conditions
Regards, Faraz Shaikh
fshaikh Excel Master
