How Excel sets Conditional formatting

Conditional formatting means that if a specified cell satisfies a specific condition, Excel uses the formatting of shading, fonts, colors, and so on, which is typically highlighted. You can use conditional formatting when you calculate results or when you want to monitor the values of cells. The details of how Excel sets conditional formatting are as follows:

One, excel2007 version set conditional formatting

1, open the Excel software, the box chooses needs to set the conditional format the range of cells, the box chooses it.

2. Select Start-style-conditional formatting-highlight cell rules to select the desired command in the pop-up list. Here we need to put the total score below 70 points in the highlight, so select "less than" command.

3. Eject the "Greater than" dialog box, and enter 70 in the "format cells larger than the following" text box, as shown in the following illustration:

Second, excel2003 set conditional formatting

EXCEL2003 format cells are similar to the way, first open excel2003, and then the same as the first box selection of cells, then click on the menu bar in the "format-conditional format" Pop-up Conditional Formatting dialog box. Then you can set it accordingly. As shown in the figure:

Classification:

• Excel Tutorials