Current location - Education and Training Encyclopedia - Graduation thesis - How to change the background color of the whole column after WPS sets the conditional format?
How to change the background color of the whole column after WPS sets the conditional format?
1. Open the table to find the format-conditional format. There are two ways to find it, one is in menu bar format, and the other is in WPS table format in the upper left corner. You can choose any one.

2. First, select a single data or a whole row and column to set, and then open the conditional format, as shown below.

3. Here, you need to select cell values and formulas as needed. After selecting the cell data, you need to select its range value.

4. After completing the form, set the following format. Click Format to display the chart below. After selecting the data representation, click OK.

5. Conditional formats can be distinguished by setting three conditions for the same data selected at the same time.