I am trying to use the Excel 2010 Conditional Formatting feature to color a cell Red, Yellow, or Green. If the cell’s value is less than 61, I want the cell color Green. If the cell’s value is between 61 and 80, I want the cell color Yellow. If the cell’s value is greater than 80, I want the cell color Red. The data is displayed as a percent. I have not been able to find what combination of choices to make this work.
Current Capacity 74%