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

Data Analysis

  • How to Create Thermometer Chart in Excel
  • Calculate Conditional Percentile ‘IF’ in table in Excel
  • How To Remove Duplicates In Excel Column Or Row?
  • How To Load Analysis ToolPak in Excel
  • How to create running total in an Excel Table

References

  • How to use Excel MMULT Function
  • Count unique text values with criteria
  • Basic INDEX MATCH approximate in Excel
  • Two-way lookup with VLOOKUP in Excel
  • MATCH function: Description, Usage, Syntax, Examples and Explanation

Data Validations

  • Excel Data validation only dates between
  • How To Create Drop-down List in Excel
  • Excel Data validation no punctuation
  • Data validation must not exist in list
  • Excel Data validation must not contain

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.

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.

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).

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:

VLOOKUP without #N/A error in Excel

Next Post:

Manipulating text strings using Left, Mid, Right, Len, Substitute 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

  • Return blank if in Excel
  • How to return blank in place of #DIV/0! error in Excel
  • How to use Excel NOT Function
  • OR function Examples in Excel
  • NOT function: Description, Usage, Syntax, Examples and Explanation

Date Time

  • Get date from day number in Excel
  • Convert date to month and year in Excel
  • Sum race time splits in Excel
  • Assign points based on late time in Excel
  • Display the current date and time in Excel

Grouping

  • If cell contains one of many things in Excel
  • How to randomly assign data to groups in Excel
  • Map text to numbers in Excel
  • Running count group by n size in Excel
  • Group numbers with VLOOKUP in Excel

General

  • Excel Autofill Cell Ranges, Copy, Paste
  • How to test a range for numbers in Excel
  • Automatically fill series of cells in Excel using AutoFill
  • Excel Operators
  • Create dynamic workbook reference to another workbook in Excel
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning