Introduction to EXCEL2007 Conditional format operation method

First, highlight the cells for the specified condition

Below, let's take a look at the specific procedure by showing the conditions for repeating the number in the secondary column of the score sheet.

Start Excel 2007 to open the results sheet workbook.

Select the Name column and switch to the Start Menu tab, click the Conditional Formatting button in the Styles group, and in the Drop-down list that appears, click the Highlight cell rule/duplicate value option, and then open the Duplicate Value dialog box, as shown in the following illustration.

Set to "repeat" or "unique," and click the Drop-down button to the right of "set to", and then, in the Drop-down list that appears, select a display format and click OK.

Second, highlight the cells for the specified criteria range

Below we highlight the total score of the top 10 students of the results cell as an example, to see the specific procedures.

Start Excel 2007 to open the results sheet workbook.

Select the total score column and switch to the Start Menu tab, click the Conditional Formatting button in the Styles group, and then in the Drop-down list that appears, click the project selection rule/value maximum 10 option to open the 10 largest Items dialog box, as shown in the following illustration.

Adjust the number on the left, and click the Drop-down button to the right of set to, and in the Drop-down list that appears, select a display format, and then click OK.

The use of data bar, color scale and icon

Excel 2007 adds the "bar", "Level", and "icon" features in the conditional formatting feature, and the three methods are identical.

Below we set the "Data bar" format to introduce the specific procedures.

Select the range of cells you want to add the data bar format to. Click the Conditional Formatting button in the Styles group, and in the Drop-down list that appears, expand the Data Bar option, and then, in the list of bar styles that appears, select an appropriate style, as shown in the following illustration.

Here, if you want to modify the properties of the data bar, levels, and icons, do the following:

Select the range of cells you want to add the data bar format to. Click the Conditional Formatting button in the Styles group, and in the Drop-down list that appears, expand the Data Bar option, and then, in the Drop-down menu that appears, select the other rules option to open the New Formatting Rule dialog box.

Click the Drop-down button to the right of the formatting style, select a style in the Drop-down list that appears, and then set the type of minimum, median, maximum, and adjust the color according to the color of the table. When all settings are complete, click the OK button to return to it, as shown in the following figure.

Iv. the application of the formula in conditional format

If the user wants to separate the behavior data to fill the different color, may use the conditional formatting function to realize.

Select the table area where you want conditional formatting to be set. Switch to the Start Menu tab, click the Conditional Formatting button in styles, and then, on the shortcut menu that appears, select the Manage Rules option to open the Conditional Formatting Rule Manager dialog box, as shown in the following illustration.

Click the New Rule button in to open the New Formatting Rule dialog box, as shown in the following illustration.

Under Select rule Type, select the option to use formulas to determine which format to use, and then enter the formula in the box under format for values that match this formula: =mod (ROW (), 2) = 1.

Click the Format button, open the Format Cells dialog box, switch to the Fill tab, select a color, OK to return to the New Formatting Rule dialog box, and then decide to return to the Conditional Formatting Rule Manager dialog box.

Repeat steps 2 through 4, and then set a color with the formula: =mod (ROW (), 2) = 0. When all settings are complete, click OK to exit.

Classification:

• Excel Tutorials