How to set the cell color to change as the data changes?

November 18, 2021
42 Views 0

Graphic skills

1. Open the table in WPS Office, select the cells that you want to set.

How to set the cell color to change as the data changes1.gif 

2. Click Home → Conditional Formatting → Highlight Cells Rules.

How to set the cell color to change as the data changes2.gif 

3. Select one of the rules as you need. Here we select Equal to for example. Fill a 5 in the text box, and select Light Red Fill with Dark Red Text. Then click OK. In the same way, we set 6 as Yellow Fill with Dark Yellow Text, and 7 as Green Fill with Dark Green Text.

How to set the cell color to change as the data changes3.gif

 

4. When the data in other cells is changed to 5, the changed cell will become Light Red Fill with Dark Red Text, and the same goes for 6 and 7.

How to set the cell color to change as the data changes4.gif  

In addition to this, you can also set other conditional formatting to meet your need!

 

For all, easy your work with WPS office suite. Free download WPS Office for PC, Mobile, Windows, Mac, Android, iOS online.