Conditional formatting highlight target percentage

To highlight a percentage value in a cell using different colors, where each color represents a particular level, you can use multiple conditional formatting rules, with each rule targeting a different threshold. In the example shown, conditional formatting is applied to the range B5:B12 using 3 formulas: =B5>=90% // green =B5>=80% // yellow =B5