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

Data Analysis

  • How to calculate average last N values in a table in Excel
  • Conditional Formatting Data bars Examples in Excel
  • Conditional Formatting New Rule with Formulas in Excel
  • Create Scatter Chart in Excel
  • How to sum a total in multiple Excel tables

References

  • How to get last row in mixed data with blanks in Excel
  • Two-column Lookup in Excel
  • How to use Excel FORMULATEXT function
  • VLOOKUP function: Description, Usage, Syntax, Examples and Explanation
  • Find closest match in Excel

Data Validations

  • Excel Data validation whole percentage only
  • Excel Data validation no punctuation
  • Excel Data validation only dates between
  • Excel Data validation number multiple 100
  • How To Create Drop-down List in Excel

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

  • IF with wildcards in Excel
  • Complete List of Excel Logical Functions, References and Examples
  • Not Equal To ‘<>‘ operator in Excel
  • OR function Examples in Excel
  • IF with boolean logic in Excel

Date Time

  • WEEKNUM function: Description, Usage, Syntax, Examples and Explanation
  • Custom weekday abbreviation in Excel
  • How to calculate workdays per month in Excel
  • Add business days to date in Excel
  • Count dates in current month in Excel

Grouping

  • Map text to numbers in Excel
  • Group times into unequal buckets in Excel
  • Running count group by n size in Excel
  • How to randomly assign data to groups in Excel
  • Map inputs to arbitrary values in Excel

General

  • How to set or clear a print area in Excel Worksheet
  • Flash Fill in Excel
  • Subtotal by color in Excel
  • Basic error trapping example in Excel
  • How to count total number of cells in a rectangular range in Excel
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning