WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android

banner

How to color cell based on value in Excel?

August 9, 2022
57.6K Views

When we work with a huge amount of data in Excel/Spreadsheet and need to highlight or color certain cells based on their values then it becomes very difficult to perform this task by changing the color of each cell one by one. Coloring the cells based on their values in Excel/Spreadsheet WPS(2016/2019/Mac/Online) helps in understanding the data and highlights the important data from the remaining cells. 

Many people are unaware of How to Color Cell Based on Value in Excel/Spreadsheet

There are different ways for doing this task. After following the below-mentioned steps, anyone can easily color a cell based on value in Excel/Spreadsheet.

Excel/Spreadsheet is an easy-to-use tool that helps its users by providing so many different methods for processing and categorizing data within a few minutes. The following steps will help you understand How to color cell based on value in Excel/Spreadsheet WPS. After reading all the steps, you will be able to color cells based on value in excel/spreadsheet WPS (2016/2019/Mac/Online) easily.

How to Color Cell Based on Value in Excel/Spreadsheet

1.Open the worksheet in Spreadsheets (WPS Office) which contains the desired data and select the data in which you want to color different cells.

2.Click on the Conditional Formatting button in the Home Tab. It will show different options, as shown below.

3.Select New Rule and then select Format only cells that contain.

4. Select the type of values that need to be colored. For example, in the below picture the values between 65 to 85 are required to be colored. After defining the values in the designated spaces, click on Format and a new window will open. 

5.Go to Patterns tab and select your desired color and click on OK. This will color cells based on their values. The pictures below show all the steps in sequence. 

How to Color Cell Based on Value of Another Cell in Excel/Spreadsheet

1.In case the color of cells is required to be changed based on the value of some specific cell then again select the data range.

2.Click on the Conditional Formatting button in the Home Tab. It will show different options. Select New Rule. 

3.Now, select Format only cells that contain. Select less than in the drop-down menu and then select the specific cell by clicking on the button in the highlighted area. 

4.Press Enter and then click on Format and select your desired color. Click on OK. 

5.The color of cells will change based on the value of the specific cell. For example, look at the pictures below.

If you change the value of the specific cell, the cells will get colored as per the formatting rule selected earlier. This is shown below.

 Note: You can repeat the same steps by selecting another formatting rule.

This article has covered the methods on How to color cells based on values in excel/spreadsheet WPS (2016/2019/Mac/Online) and how to color cells based on value of a specific cell in excel/spreadsheet WPS (2016/2019/Mac/Online). You can use these simple steps as explained above and easily color cells based on their values in your WPS Excel/Spreadsheet (2016/2019/Mac/Online) whenever required.

Learn More about How to Color Cells Based on Values in Excel/Spreadsheet

Hopefully, you have learned How to color cells based on values in WPS Excel/Spreadsheet (2016/2019/Mac/Online) by following the above steps.  If you want to know more about Excel features, you can follow WPS Academy to learn. You can also download WPS Office to edit excel spreadsheets, word documents, and PowerPoint for free of cost. Download now! And get an easy and enjoyable working experience.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.