Excel 2007 how to highlight cells

1. Highlight cells with specified conditions

The following uses the condition of displaying duplicate student numbers in the student ID column in the student list as an example to see the specific operation process:

1. Start Excel 2007 and open the workbook.

2. Select the name column, switch to the "Start" menu tab, and click "condition format" in the "style" group. In the drop-down list that appears later, click the "highlight cell rules"/"duplicate value" options in turn to open the "duplicate value" dialog box, as shown in the following figure.

Repeated value

3. Set "repeat" or "unique", click the drop-down button on the right of "set as", and select a display format from the drop-down list that appears later, click OK.

2. Highlight cells in the specified condition range

Next we will take the result cell of the top 10 students with a highlighted total score as an example to look at the specific operation process.

1. Start Excel 2007 and open the workbook.

2. Select the total score column, switch to the "Start" menu tab, and click "condition format" in the "style" group. In the drop-down list that appears later, click "project selection rules"/"10 items with the maximum value" to open the "10 items with the maximum value" dialog box.

3. Adjust the number on the left and click the drop-down button on the right of "set to". In the displayed drop-down list, select a display format and click "OK.

3. Use of data entries, levels, and icons

In the condition format function of Excel 2007, the "data Bar", "color level", and "icon" functions are added. The usage of the three functions is the same.

The following describes how to set the "data entry" format:

1. Select the cell area for which you want to add the data entry format. Click the "condition format" button in the "style" group. In the subsequent drop-down list, expand the "data Bar" option. In the subsequent data bar style list, select a suitable style ..

2. If you want to modify the attributes of "data Bar", "color level", and "icon", follow these steps:

3. Select the cell area for which you want to add the data entry format, click the "conditional format" button in the "style" group, and expand the "data entry" option in the drop-down list that appears later, select "other rules" from the drop-down menu that appears to open the "new format rule" dialog box.

4. Click the drop-down button on the right of "format style" and select a style from the drop-down list that appears later; set the "minimum", "median", and "maximum" types, and adjust the color based on the color matching of the table. After all settings are complete, click OK to return.

IV. Application of formulas in condition format

1. If you want to fill different colors with behavior data, you can use the conditional format function.

Select the table area where you want to set the condition format, switch to the "Start" menu tab, click the "condition format" button in "style", and in the shortcut menu that appears later, select "manage rules" to open the "conditional format rule manager" dialog box.

2. Click "new rule" to open the "new format rule" dialog box.

3. Under "select rule type", select the "use formula to determine the format to use" option, and enter a formula in the box below "set format for values that conform to this formula: = MOD (ROW (), 2) = 1.

4. Click the "format" button to open the "set cell format" dialog box, switch to the "fill" tab, select a color, and return to the "new format rule" dialog box, then confirm to return to the "condition format rule manager" dialog box.

5. Repeat steps 2 to 4 and set a color. The formula is: = MOD (ROW (), 2) = 0. After all settings are complete, click OK to exit.

In Excel 2007, the data in a column cell in an Excel 2007 table meets the specified conditions and can be automatically identified. To a certain extent, it reduces the user's data analysis work, which is a practical trick.