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

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



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

STEP 2: Go to Home > Conditional Formatting


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

Helpful Resource:


If you like this Excel tip, please share itEmail this to someone


Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Conditionally Formatting A Drop Down List In a previous post I showed you how to Create a Drop Down List in a Table.    We are now going to take this concept one level further and apply some conditional formatting to the drop down data validation list.This is useful if you want to highlight when a job is completed, c...
Turn Text Dates To Excel Dates With Text To Column... Whenever you import data from your company's server, ERP system or any other source for that matter, the Dates usually come in a TEXT format.I will show you a cool trick where you can turn the TEXT Date to a values Date that Excel can read and work with.DOWNLOAD EXCEL WOR...
How To Create A Custom List In Excel  A Custom List in Excel is very handy to fill a range of cells with your own personal list. It could be a list of your team members at work, countries, regions, phone numbers or customers.The main goal of a custom list is to remove repetitive work and manual errors i...
Create a Named Range in Excel Whenever I work with spreadsheets, there's no escaping the fact that I have to work with a lot of ranges.Some of these ranges I have to reuse time and time again to create different calculations!Good thing there are Named Ranges in Excel!By using a Named Range, you ca...