Conditional Formatting for data visualization

November 4, 2021
Views

A free Office suite fully compatible with Microsoft Office

Free Download

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.

Conditional Formatting for data virtualization (2).gif

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

Conditional Formatting for data virtualization (3).png

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.

Conditional Formatting for data virtualization (4).gif

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

Conditional Formatting for data virtualization (5).png

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.

Was this helpful?