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 Conditional Formatting, point to Data Bars, and then click the colored data bar that you want.

Excel 2007 Data Bars

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.

Excel 2007 New Formatting Rule dialog box

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.

Excel 2007 the ragne of cells

To do this task, do the following:

1. Select the range of cells (D2:D8)  that you want to format.

2. On the Home tab, in the Styles group, click Conditional Formatting, point to Data Bars, and then click the colored data bar that you want (e.g. Purple Data Bar).

Excel 2007 result of formatting with Data Bars

Notes:

- 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.

Excel 2007 clear formatting in the cell

 


HTML Comment Box is loading comments...



This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages:
C, C++, C#, Java, VB.NET, Python, VBA,PHP & Mysql, SQL, JSP, ASP.NET,HTML, CSS, JQuery, JavaScript and other applications such as MS Excel, MS Access, and MS Word. However, we don't guarantee all things of the web are accurate. If you find any error, please report it then we will take actions to correct it as soon as possible.