Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • How to use Excel VLOOKUP Function
  • VLOOKUP function: Description, Usage, Syntax, Examples and Explanation
  • How to create dynamic named range with OFFSET in Excel
  • Find closest match in Excel
  • How to use Excel MATCH Function

Data Analysis Examples

  • How To Compare Two Lists in Excel
  • How To Create Pareto Chart in Excel
  • Conditional Formatting Icon Sets Examples in Excel
  • Conditional Formatting Rules in Excel
  • Data Series in Excel

Data Validation Examples

  • Excel Data validation must not contain
  • Excel Data validation allow uppercase only
  • Prevent invalid data entering in specific cells
  • Excel Data validation require unique number
  • Excel Data validation specific characters only

Conditional Formatting Color Scales Examples in Excel

by

Color Scales in Excel make it very easy to visualize values in a range of cells. The shade of the color represents the value in the cell.

To add a color scale, execute the following steps.

1. Select a range.

2. On the Home tab, in the Styles group, click Conditional Formatting.

3. Click Color Scales and click a subtype.

Worked Example:   Highlight cells that begin with in Excel

Result:

Explanation: by default, for 3-Color scales, Excel calculates the 50th percentile (also known as median, middle value or midpoint). The cell that holds the minimum value (9) is colored red. The cell that holds the median (36) is colored yellow, and the cell that holds the maximum value (80) is colored green. All other cells are colored proportionally.

Worked Example:   Highlight integers only in Excel

Read on to further customize this color scale.

4. Select the range A1:A7.

5. On the Home tab, in the Styles group, click Conditional Formatting, Manage Rules.

6. Click Edit rule.

Excel launches the Edit Formatting Rule dialog box. Here you can further customize your color scale (Format Style, Minimum, Midpoint and Maximum, Color, etc).

Worked Example:   Highlight approximate match lookup conditional formatting in Excel

Note: to directly launch this dialog box for new rules, at step 3, click More Rules.

7. Select 2-Color Scale from the Format Style drop-down list and select white and blue.

8. Click OK twice.

Result.

Post navigation

Previous Post:

How to Delete Cells, Row and Rows in Excel

Next Post:

Count Number of Words 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
  • Join first and last name — Manipulating NAMES in Excel
  • REPLACE, REPLACEB functions: Description, Usage, Syntax, Examples and Explanation
  • How to check if cell contains some words but not others in Excel
  • How to get last line in cell in Excel
  • How to compare two text strings in Excel
  • Count birthdays by month in Excel
  • Add workdays no weekends in Excel
  • Convert Excel time to decimal seconds
  • Next biweekly payday from date in Excel
  • Get project midpoint in Excel
  • Compound Annual Growth Rate CAGR formula examples in Excel
  • DURATION function: Description, Usage, Syntax, Examples and Explanation
  • PPMT function: Description, Usage, Syntax, Examples and Explanation
  • DISC function: Description, Usage, Syntax, Examples and Explanation
  • ISPMT function: Description, Usage, Syntax, Examples and Explanation
Acronyms, Abbreviations, Initialism & What They Stand For
© 2022 xlsoffice . All Right Reserved. | Teal Smiles