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.
Windows • MacOS • Linux • iOS • Android
Conditional Formatting for data visualization
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 tab→click 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.
Also Read:
- 1. How to create dynamic charts for data visualization in excel
- 2. How to use conditional formatting in excel to highlight cells
- 3. 10 Gorgeous Excel Graph Templates for Data Analysis and Visualization
- 4. How to do Excel Conditional Formatting Based on Another Cell Text
- 5. Conditional formatting in Excel—Highlight
- 6. 10 Excel Graph Paper Templates to Make Data Visualization Easy