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.
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.
3. Click Ok button.
For example, use the following range of cells to format it with Color Scales.
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).
- 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.
This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages: