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


Conditional Formatting for data visualization

June 6, 2023

The Conditional Formatting function can format cells fulfiling specific conditions. We can visualizate data with this function.

1. Select an array for conditional formatting.

2. Go to the Home tabclick Conditional Formatting.

3. Choosing the Manage Rule... option to pop up the Conditional Formatting Rules Manager dialog.

Customize (Manage) Rules for Conditional Formatting

4. Click New Rule to pop up the New Formatting Rule dialog, where you can access settings of conditions and cell formats. Here are two cases of data visualization.

Case 1 use Icon Sets of different color to mark the value ranges. Each color indicates a specific value range.

Case 1: Conditional Formatting (Icon Sets style) to indicate number range

Case 1 Result: Conditional Formatting (Icon Sets style)

Case 2 presents Data Bars in the selected cells. With Data Bars, we can directly compare values within an array.

Case 2: Conditional Formatting (Data Bar style) to visualize data

Case 1 Result: Conditional Formatting (Icon Sets style)

To be Office Excel advanced, you could learn relevant skills of WPS Office Spreadsheet onlinein 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.