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

Data Analysis

  • How To Insert and Customize Sparklines in Excel
  • How to calculate current stock or inventory in Excel
  • How To Create Pareto Chart in Excel
  • How to create Checklist in Excel
  • How to combine 2 or more chart types in a single chart in Excel

References

  • Find Closest Match in Excel Using INDEX, MATCH, ABS and MIN functions
  • Extract all partial matches in Excel
  • How to get first column number in range in Excel
  • INDEX function: Description, Usage, Syntax, Examples and Explanation
  • MATCH function: Description, Usage, Syntax, Examples and Explanation

Data Validations

  • Excel Data validation with conditional list
  • Excel Data validation unique values only
  • Excel Data validation whole percentage only
  • Excel Data validation require unique number
  • Excel Data validation don’t exceed total

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 every other row 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:   Conditional Formatting Rules 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:   Conditional formatting gantt chart 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

Logical Functions

  • IFERROR function: Description, Usage, Syntax, Examples and Explanation
  • Check multiple cells are equal in Excel
  • IF function: Description, Usage, Syntax, Examples and Explanation
  • SWITCH function: Description, Usage, Syntax, Examples and Explanation
  • TRUE function: Description, Usage, Syntax, Examples and Explanation

Date Time

  • Convert date to month and year in Excel
  • Get day from date in Excel
  • Steps to create Dynamic calendar grid in Excel
  • How to show last updated date stamp in Excel
  • Get days before a date in Excel

Grouping

  • Group times into unequal buckets in Excel
  • Group numbers with VLOOKUP in Excel
  • Categorize text with keywords in Excel
  • If cell contains one of many things in Excel
  • Calculate conditional mode with criteria in Excel

General

  • How to create dynamic worksheet reference in Excel
  • How to test a range for numbers in Excel
  • Creating and Opening an existing file in Excel
  • Advanced Number Formats in Excel
  • Find Most Frequently Occurring Word in Excel Worksheet
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning