How to Compare Current and Previous Scores Using Excel Icon Sets
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.

- 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.
Ensure that your current and previous score columns are correctly aligned in adjacent columns to allow for simple row-by-row cell referencing.
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.
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.
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.
With the column still selected, click 'Conditional Formatting' again and choose 'Manage Rules'. Select your Icon Set rule and click 'Edit Rule'.
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'.

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. Open your data file: Launch WPS Spreadsheet and open the document containing your score columns.
- 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. Apply visual icons: Highlight the results, navigate to the 'Home' tab, click 'Conditional Formatting', and select 'Icon Sets'.
- 4. Customize the display: Click 'Manage Rules', check the 'Show Icon Only' option, and adjust the value thresholds to match your specific needs.

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.




