Microsoft Excel 2007 tutorial: coditional formatting color scales


Conditional Formatting Color Scales

IV. Conditional Formatting Color Scales

You use Color Scales to display a two or three color gradient in a range of cells. The type or degree of the color represents the value in the cell. When you format cells with Color Scales, you can format them with a predefined gradient color or you can format them with your own gradient color. To use Color Scales, do the following:

1. Select the range of cells that you want to format.

2. On the Home tab, in the Styles group, click Condition Formatting, point to Color Scales, and then click the gradient color that you want.

Excel 2007 Color Scales

To format cells with your own gradient color, do the following:

1. Follow step 1 and 2 above, and then click More Rules.

2. In the New Formatting Rule dialog box, under Format all cells based on their values, click the Format Style box to select 2-Color Scale or 3-Color Scale. Under Minimum and Maximum, in the Type boxes, you can choose the type for the value that you want to format with. In the Value boxes enter the values base on their types. And then in the Color boxes, select the color for minimum and maximum values 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. In the Preview box, you can see the shade of color will be used to format in the cells.

Excel 2007 New Formatting Rule Color Scales

3. Click Ok button.

For example, use the following range of cells to format it with Color Scales.

Excel 2007 the ragne of cells

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. Red - Yellow -Blue Color Scale).

Excel 2007 result of format cells with color scales

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 cell, you can use Clear Rules command. To use this command, do the following:

1. Select the cell 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

 


Comments

Michael Leng comment

 Michael Leng

Clean and Clear article. I like yours.


2013-12-13




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.