Chart & Visualization Issues

How to Compare Current and Previous Scores Using Excel Icon Sets

Adam DavisAdam Davis Nov 10, 2026 870 views

Question details

The user wants to visually indicate whether current scores have increased, decreased, or stayed the same compared to previous scores using conditional formatting, without losing existing score-based colors.

How to Compare Current and Previous Scores Using Excel Icon Sets
Product
Excel
Device & OS
not provided
Scenario
Visualizing performance changes or data trends between two columns of numerical data.
Observed behavior
Needs to display directional indicator icons (like arrows) while ensuring the original cell formatting and colors remain intact.
Before you start

Ensure that your current and previous score columns are correctly aligned in adjacent columns to allow for simple row-by-row cell referencing.

Solution 1Recommended

Use a Helper Column with Icon-Set Conditional Formatting

This method calculates the difference between the two scores in a new column and applies visual indicators based on the calculated result, preserving your original formatting.

Applying conditional formatting directly to the score columns can overwrite existing cell colors. By utilizing a helper column, you can cleanly display visual indicators without altering the original data presentation.

1
Create a helper column

Insert a new column next to your scores (e.g., Column H). Type the formula to calculate the difference, such as =F2-G2 (or =G2-F2 depending on your layout), and press Enter. Drag the fill handle down to apply the formula to the rest of the rows.

2
Apply Icon Sets

Highlight the newly created helper column. Go to the 'Home' tab, click on 'Conditional Formatting', hover over 'Icon Sets', and select the directional arrows or shapes you prefer.

3
Configure the formatting rules

With the column still selected, click 'Conditional Formatting' again and choose 'Manage Rules'. Select your Icon Set rule and click 'Edit Rule'.

4
Adjust values and hide numbers

In the rule settings, assign positive values for increases (e.g., green up arrow), negative values for decreases (e.g., red down arrow), and zero for unchanged scores. Check the 'Show Icon Only' box to hide the numerical difference, then click 'OK'.

Use a Helper Column with Icon-Set Conditional Formatting
Original Colors Preserved: Using a separate helper column for the icons guarantees that any existing background color or text formatting in your original score columns remains completely unaffected.
Efficient Data Visualization

Easily Compare Data Trends with WPS Spreadsheet

WPS Spreadsheet provides robust and intuitive conditional formatting tools, making it incredibly simple to compare datasets, apply customized icon sets, and visualize trends without complex configurations.

  1. 1. Open your data file: Launch WPS Spreadsheet and open the document containing your score columns.
  2. 2. Insert the subtraction formula: Add a new helper column and input the subtraction formula to find the difference between the current and previous scores.
  3. 3. Apply visual icons: Highlight the results, navigate to the 'Home' tab, click 'Conditional Formatting', and select 'Icon Sets'.
  4. 4. Customize the display: Click 'Manage Rules', check the 'Show Icon Only' option, and adjust the value thresholds to match your specific needs.
Fully compatible with Microsoft Excel (.xlsx) formulas and formattingIntuitive conditional formatting rule managerExtensive library of icon sets, color scales, and data barsFree and lightweight spreadsheet software for everyday use
microsoft office alternative - wps office

Frequently Asked Questions

Can I apply icon sets directly to the current score column without a helper column?

While you can apply icon sets directly to a single column, doing so evaluates the scores against a fixed threshold or the average of that specific column. For a direct row-by-row comparison against a previous column, a helper column is required.

How do I change the specific icons used in the conditional formatting?

You can customize the icons by going to 'Conditional Formatting' > 'Manage Rules'. Edit your active rule, and in the 'Icon' dropdown menus next to each condition, you can mix and match different pre-set icons.

What if I want to show percentage change instead of absolute difference?

You can modify the helper column formula to calculate the percentage difference, such as =(F2-G2)/G2. Afterward, open the conditional formatting rules, change the evaluation 'Type' from 'Percent' to 'Number', and input your decimal thresholds.

Will checking the 'Show Icon Only' option delete my subtraction formula?

No, checking 'Show Icon Only' only affects the visual display of the cell. It hides the numerical output so only the visual icon is shown, but the underlying formula remains perfectly intact and will continue to update automatically if the scores change.