Home  >  Article  >  Software Tutorial  >  How to set color levels based on data in WPS tables How to set color levels based on data in WPS tables

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

WBOY
WBOYOriginal
2024-09-02 10:10:50904browse

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.

WPS表格怎么根据数据设置色阶 WPS表格数据设置色阶的方法

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

WPS表格怎么根据数据设置色阶 WPS表格数据设置色阶的方法

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.

WPS表格怎么根据数据设置色阶 WPS表格数据设置色阶的方法

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

WPS表格怎么根据数据设置色阶 WPS表格数据设置色阶的方法

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

WPS表格怎么根据数据设置色阶 WPS表格数据设置色阶的方法

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn