Use color scales to make the temperature chart

Uploaded time: October 22, 2021 Difficulty Beginner

A free Office suite fully compatible with Microsoft Office

Free Download

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.