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.