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!