Microsoft Excel 2007 tutorial: Conditional Formatting Data Bars
Conditional Formatting Data Bars
III. Conditional Formatting Data Bars
You use Data Bars to view a colored data bar in the cell. The length of data bar represents the value in the cell. A longer bar represents a higher value. When you format cells with Data Bars, you can format them with a predefined colored data bar or you can format them with your own colored data bar. To use Data Bars, do the following:
1. Select the cells that you want to format.
2. On the Home tab, in the Styles group, click Condition Formatting, point to Data Bars, and then click the colored data bar that you want.
To format cells with your own colored data bar, do the following:
1. Follow step 1 and 2 above, and then click More Rules.
2. In the New Formatting Rule dialog box, click the Bar Color box to select the color that you like on the color palette. If you cannot find your color on the color palette, click More Colors. In the Color dialog box, click Standard tab or Custom tab to select the color which you want, and then Ok button.
The Preview box shows the color that will be used to format in the cells.
Note: If you want to display only colored bar in the formatted cells, select Show Bar Only check box. In the New Formatting Rule dialog box, under Shortest Bar and Longest Bar, in the Type boxes, you can select the type for the value in the cell ; and then in the Value boxes, type the values base on their types.
3. Click Ok button.
For example, use the following range of cells to format it with Data Bars.
To do this task, do the following:
1. Select the range of cells (A2:D8) that you want to format.
2. On the Home tab, in the Styles group, click Condition Formatting, point to Data Bars, and then click the colored data bar that you want (e.g. Purple Data Bar).
- If you want to create new rule, edit or delete existing rule, and view all conditional formatting rules in the workbook, click the cell that is formatted, and then on the Home tab, in the Style group, click Conditional Formatting, and then click Manage Rules. In the Conditional Formatting Rules Manager dialog box, you can do what we have mentioned.
- If you only want to clear format in the cells, you can use Clear Rules command. To use this command, do the following:
1. Select the cells that you want to clear.
2. On the Home tab, in the Styles group, click Conditional Formatting, point to Clear Rules, and then click Clear Rules form Selected Cells. If you click Clear Rules from Entire Sheet, all formats in the worksheet will be cleared.