Free All-in-One Office Suite with PDF Editor
Edit Word, Excel, and PPT for FREE.
Read, edit, and convert PDFs with the powerful PDF toolkit.
Microsoft-like interface, easy to use.
Windows • MacOS • Linux • iOS • Android
How to set the cell color to change as the data changes?
1. Open the table in WPS Office, select the cells that you want to set.
2. Click Home → Conditional Formatting → Highlight Cells Rules.
3. Select one of the rules as you need. Here we select Equal tofor 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.
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.
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.
Also Read:
- 1. How to set the text color of the text comment box in the PDF file
- 2. How to color cell based on value in Excel?
- 3. How to set the background color in the PDF file free?
- 4. How to set the color of highlight area in PDF?
- 5. Set transparent color for pictures in a slide
- 6. How to set underline color in PDF?