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!

 

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