How to set color levels based on data in WPS tables How to set color levels based on data in WPS tables

wps is a very easy-to-use office software with very rich and powerful functions. So if you want to set the color gradient effect in an excel table, how do you do it? In fact, the operation method is very simple. Next, the editor will introduce the specific steps of setting the color levels. Let’s take a look below! 1. Double-click to open the WPS form on your computer.

2. After selecting the data area, click Conditional Formatting - Color Levels in the Home tab, and click to select a desired color level effect.

3. Click on other rules in the sub-option of color scale. In the window that opens, you can choose two-color or three-color scale.

4. Then you can adjust the color effect according to your actual needs.

5. If necessary, you can also click to set the data bar effect, set the icon set, etc.

The above is the detailed content of How to set color levels based on data in WPS tables How to set color levels based on data in WPS tables. For more information, please follow other related articles on the PHP Chinese website!