Excel Video 48 covers a Conditional Formatting tool called Data Bars. Data Bars are simply a way to format the background of the cell with a fill color based on how high or low the data in the cell is. Excel offers 6 one-click pre-formatted Data Bars to choose from and automatically calculates the high and low points in the range of data you select.
I also spend a few minutes talking about how to customize the Data Bars. Excel’s Conditional Formatting offers some fast preset formats that are easy to use, but Excel also makes it easy to modify the formatting to meet your needs. Watch Excel Video 48 to see how easy it is to change the colors and the way Excel determines which cells are high and low.