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

DOWNLOAD EXCEL WORKBOOK

 

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:

MOTH-excel_expert470x63

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

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Show The Percent Of With Excel Pivot Tables  Excel Pivot Tables have a lot of useful calculations under the SHOW VALUES AS option and one that can help you a lot is the PERCENT OF calculation.It will display the value of one item (the Base Field) as the percentage of another item (the Base Item).This optio...
Clear a #REF! Error in Excel When your Excel workbook has formulas that are linked to other workbooks/cells that have been deleted, you will get a #REF! error.This means that the formula refers to a cell that isn’t valid.To get rid of this error message we have to select the cell(s) with this error, ...
Show Averages With an Excel Pivot Table A Pivot Table is the most powerful feature within Excel as it allows you to analyze your data in many different ways, all with a press of a button.The Summarize Values By option allows you to choose a type of calculation (Sum, Count, Average, Max, Min, Count Numbers Produ...
Add Hyphens To Serial Numbers Using Excel Flash Fi...  Flash Fill in Excel is a new feature that was introduced in Excel 2013.Flash Fill allows you to combine, extract, move & transform data that belongs in one column, into a new column.One of the cool uses of Flash Fill is formatting numbers.  In our example be...