Pinterest Pixel

Data Bars, Color Scales & Icon Sets

John Michaloudis
Data Bars, Color Scales & Icon Sets.
Conditional Formatting has improved in Excel 2010 with the introduction of Data Bars, Color Scales & Icon Sets.
Data Bars, Color Scales & Icon Sets | MyExcelOnline Data Bars, Color Scales & Icon Sets | MyExcelOnline

Data Bars: Includes graphic bars in a cell, proportional to the cell’s value – Good for Financial Analysis

Color Scales: Includes a background color, proportional to the cell’s value – Good for Heat Maps

Icon Sets: Shows icons in a cell. The icons depend on the cell’s value – Good for Project Management reports

Download excel workbookData-Bars-Color-Scales-Icon-Sets.xlsx

 

STEP 1: Select the range that you want to apply the conditional formatting on.

Data Bars, Color Scales & Icon Sets

STEP 2: Go to Home > Conditional Formatting

Data Bars, Color Scales & Icon Sets

 

STEP 3: It’s time to have fun! Select a Data Bar, Color Scale, or Icon Set and see what happens!

Data Bars, Color Scales & Icon Sets

Data Bars, Color Scales & Icon Sets

Data Bars, Color Scales & Icon Sets

 

If you like this Excel tip, please share it
Founder & Chief Inspirational Officer at

John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship MyExcelOnline Academy Online Course.

See also  Excel Table: Row Calculations

Steps To Follow

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...