WPS Office

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.

Free Download

Windows • MacOS • Linux • iOS • Android


Use color scales to make the temperature chart

Uploaded time: October 22, 2021 Difficulty Beginner

Use color scales to make the temperature chart

Use color scales to make the temperature chart

The table shows the minimum temperature data of each month in a specific area. We can visually display the temperature changes through the color scale feature of the conditional formatting.

We select the cell range B2:M2 and get into the Home tab. Click the Conditional Formatting drop-down button, and choose the Color Scales option. In the pop-up menu, we can select Red-White-Bule Color Scale.

At this time, the selected table area will be marked with color. The higher the temperature, the deeper the red; the lower thetemperature, the deeper the blue.

To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy.

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