< Go Back

Conditional formatting highlight target percentage

In excel, conditional formatting highlight target percentage is used to make numerical values simple to understand with the help of illustrations. It allows formatting the cell or its text regarding a specific condition. Different colors are used to highlight the percentage value in the cell with color indicating a different level.

Formula

The formula for conditional formatting highlight target percentage is given below

=A1>=X

=A1>=Y

=A1<Y

Explanation

In excel conditional formatting highlight target percentage rules are assessed in the following order:

  • In every cell of B5:B12, the first equation is assessed. Value equal to or greater than 90% will be TRUE and represented by Green color. Value not equal to or greater than 90% will be FALSE thereby leading to the inactivation of the rule.
  • In every cell of B5:B12, second equation is assessed. Value equal to or greater than 80% will be TRUE and represented by Yellow color.
  • In every cell of B5:B12, third equation is assessed. Value less than 80% will be TRUE and represented by Pink color.

Example

In this example, we have applied conditional formatting to the B5:B12 as shown in the figure. We have used three formulas

=B5>=90% // green

=B5>=80% // yellow

=B5<80% // pink

Figure 1 Example of conditional formatting highlight target percentage

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California
This blog is one way to figure it out. A 20 minute chat session with an expert is a better way.Get step-by-step guidance on your question

Leave a Comment

avatar