Current location - Education and Training Encyclopedia - Graduation thesis - How does wps conditional format fill the color of lines?
How does wps conditional format fill the color of lines?
You can use conditional formatting to create new rules for filling colors. Please refer to the following:

For example, when the value of column A is greater than or equal to 10, the row is filled with yellow.

1, select the whole line from 1 to 10, and start tab- conditional format-new rule;

2. Use the formula to select the cells to be formatted, and enter the formula = $ a1> = 10 (pay attention to the cell reference method);

3. Click Format, select yellow in the Fill tab and confirm;

4. done.