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

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin