How do I set conditional formatting in Excel

In Excel, if you often do data table friends, the conditional format must be very familiar with, in fact, to meet certain conditions of the cell, make a eye-catching logo, can be font or color, etc. above changes. In fact, this is a very practical Excel skills, we can come to learn.

Excel

One, excel2007 version set conditional format.

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.

Conditional formatting

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:

Enter numeric values

Second, excel2003 set conditional format.

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:

Conditional formatting

This is the way to set conditional formatting. In fact, when you do the data table, the appropriate use of conditional formatting, you can make some data tables more clear. If you can also use Excel, you might as well learn.