Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • Remove Duplicates Example in Excel
  • How to create a Histogram in Excel
  • Chart Axes in Excel
  • Filter Data Based on Date in Excel
  • Get column name from index in Excel Table

References

  • How to use Excel TRANSPOSE Function
  • How to use Excel LOOKUP Function
  • Perform case-sensitive Lookup in Excel
  • Count rows with at least n matching values
  • How to use Excel MATCH Function

Data Validations

  • Excel Data validation unique values only
  • Excel Data validation number multiple 100
  • Excel Data validation with conditional list
  • Excel Data validation allow weekday only
  • Excel Data validation must contain specific text

Conditional formatting highlight target percentage in Excel

by

This tutorial shows how to work Conditional formatting highlight target percentage in Excel using the example below;

 Formula

=A1>=X
=A1>=Y
=A1<Y

Explanation

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<80% // pink

Note: formulas are entered relative to the upper left cell in the range, which is B5 in this example.

How this formula works

Conditional formatting rules are evaluated in order.

  1. For each cell in the range B5:B12, the first formula is evaluated. If the value is greater than or equal to 90%, the formula returns TRUE and the green fill is applied. If the value is not greater than or equal to 90%, the formula returns FALSE and the rule is not triggered.
  2. For each cell in the range B5:B12, the second formula is evaluated. If the value is greater than or equal to 80%, the formula returns TRUE and the yellow fill is applied.
  3. For each cell in the range B5:B12, the third formula is evaluated. If the value is less than 80%, the formula returns TRUE and the pink fill is applied.

The “stop if true” option is enabled for the first two rules to prevent further processing, since the rules are mutually exclusive.

Post navigation

Previous Post:

VLOOKUP with two client rates in Excel

Next Post:

How to Create Gantt Chart in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • TRUE function: Description, Usage, Syntax, Examples and Explanation
  • Extract multiple matches into separate rows in Excel
  • IFNA function: Description, Usage, Syntax, Examples and Explanation
  • Nested IF function example in Excel
  • Check multiple cells are equal in Excel

Date Time

  • Dynamic date list in Excel
  • Convert Excel time to Unix time in Excel
  • Calculate retirement date in Excel
  • DAYS function: Description, Usage, Syntax, Examples and Explanation
  • Calculate expiration date in Excel

Grouping

  • How to randomly assign people to groups in Excel
  • Categorize text with keywords in Excel
  • How to randomly assign data to groups in Excel
  • Group numbers at uneven intervals in Excel
  • Map text to numbers in Excel

General

  • How to get original price from percentage discount in Excel
  • Count cells that do not contain errors in Excel
  • Find, Select, Replace and Go To Special in Excel
  • How to calculate percent of goal in Excel
  • Spell Check in Excel
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning