Conditional formatting features for WPS tables

Daughter Xiao Jia: today to learn a trick, you can make a complicated spreadsheet on the focus, is the WPS table 2005 Conditional formatting function.

Conditional formatting is when a cell content satisfies a condition that is automatically applied to the cell's format, in other words, if you want to apply a special format to some qualifying cells, you can easily implement the conditional formatting feature. If conditional formatting is combined with formulas, Office will become more efficient.

1. Application Example: An enterprise wants to highlight in a worksheet the second-quarter results higher than the first quarter of the product.

2. In the worksheet, there are all products in the first quarter and the second quarter of the performance. Using conditional formatting features, you can highlight products in the second quarter that are higher than the first-quarter results in a formatted format.

Note that if you change the first-quarter and second-quarter performance figures, the format will be adjusted accordingly, depending on the amount of change.

The following is a detailed procedure.

1. Create a worksheet for an efficient office experience.

2. Select cell A2:c11, and then select menu command Format > Conditional formatting, select formula in the leftmost left of the Conditional Formatting dialog box, and then enter the formula in the right input box: = $C 2> $B 2.

3. Click the Format button to open the Format Cells dialog box to format the cells that match the criteria, such as setting the font size to 12th, and font style to bold italic.

This article pictures from Jinshan

4. After setting up Click OK, go back to the original dialog box, and then click OK.