Excel 2007 How to quickly identify a conforming cell

Using Excel 2007来 to input data, this is the most basic operation, and for input data analysis this is its value. We know that you can use text styles to highlight the contents of a cell, this is just the primary level, want to make a point, to learn the Excel 2007 piece format settings.

　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.

　　Duplicate value

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.

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 to, click the Conditional Formatting button in the Styles group, expand the Data Bar option in the Drop-down list that appears, and then select an appropriate style in the list of bar styles that appears ...

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.

　　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 formatted, switch to the Start Menu tab, click the Conditional Formatting button in style, and then, on the shortcut menu that appears, select the Manage Rules option to open the Conditional Formatting Rule Manager dialog box.

Click the new Rule button in which to open the New Formatting Rule dialog box.

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.

The settings for the Excel 2007 strip format, which means that in an Excel 2007 table, the data in a column cell can be automatically identified if it meets the specified criteria. To a large extent, to reduce the user's data analysis work, which is very practical in the work of the coup.