Copilot in Excel Issues

How to Add Conditional Formatting Icons Using Copilot in Excel

Khadija KhanKhadija Khan Nov 10, 2026 868 views

Question details

The user wants to automatically apply icon-set conditional formatting to data columns using Copilot in Excel.

How to Add Conditional Formatting Icons Using Copilot in Excel
Product
Microsoft Excel
Device & OS
not provided
Scenario
Visualizing numeric and percentage data columns with relative value indicators such as green, yellow, and red arrows.
Observed behavior
Copilot successfully generates and applies three-arrow rules to specific ranges, or the user manually applies icon sets via the Home tab if Copilot is unavailable.
Before you start

Ensure you have an active Microsoft 365 subscription with Copilot enabled, and verify that the data you want to format is organized as an official Excel Table.

Solution 1Recommended

Apply Icon Sets Using Copilot Prompts

Use natural language commands to let Copilot analyze your table and automatically apply the appropriate conditional formatting icons.

Copilot in Excel can quickly interpret your numeric or percentage result columns and map them to visual indicators, saving you the time of manually defining conditional formatting rules.

1
Select the Target Table

Click anywhere inside the Excel Table that contains the numeric or percentage data you want to format.

2
Open Copilot

Click the Copilot button located on the Home tab of the Excel ribbon to open the Copilot pane.

3
Enter the Formatting Prompt

In the chat box, type a prompt such as: 'Add an icon set to both results columns' and submit the request.

4
Review and Apply

Copilot will suggest applying three-arrow rules to the identified ranges (e.g., C3:C23 and D3:D23). Review the suggestion and click 'Apply' to finalize.

Apply Icon Sets Using Copilot Prompts
Format Adjustment: Copilot usually defaults to standard green, yellow, and red directional arrows, which are ideal for highlighting positive, neutral, and negative trends.
Efficient Data Visualization in WPS Spreadsheet

Easily Apply Conditional Formatting Icons with WPS Office

WPS Spreadsheet offers a highly intuitive and feature-rich interface for applying conditional formatting and icon sets. You can instantly visualize your data trends using built-in indicators, shapes, and arrows, while enjoying seamless compatibility with standard Excel files.

  1. 1. Open Data in WPS Spreadsheet: Launch WPS Office, open your spreadsheet, and highlight the columns containing your numeric or percentage values.
  2. 2. Access Conditional Formatting: Navigate to the 'Home' tab and click on the 'Conditional Formatting' icon.
  3. 3. Select Icon Sets: Choose 'Icon Sets' from the menu and click on the 3-Arrows style (or any other preferred indicator) to instantly visualize your data.
100% compatible with Microsoft Excel (.xlsx) conditional formatting rulesExtensive built-in library of icon sets, color scales, and data barsLightweight, fast performance for handling large data tables seamlesslyIntegrated WPS AI for intelligent data insights and formula assistance
microsoft office alternative - wps office

Frequently Asked Questions

Why isn't Copilot applying the formatting to my selected range?

Copilot in Excel functions best when your data is formatted as an official Excel Table. If your data is just a normal range, highlight it, press Ctrl+T (or go to Insert > Table), and then try sending your prompt to Copilot again.

Can I customize the values that trigger each color in an icon set?

Yes. After the icon set is applied (either by Copilot or manually), go to Home > Conditional Formatting > Manage Rules. Select the icon set rule and click 'Edit Rule' to adjust the specific percentage or numeric thresholds for the green, yellow, and red icons.

Can conditional formatting icon sets be applied to text columns?

No, icon sets are strictly designed to evaluate numerical values, percentages, or dates to determine relative ranking. They will not function correctly on text-only columns.

Will WPS Office preserve the conditional formatting rules created by Excel Copilot?

Yes. WPS Office is highly compatible with Microsoft Excel file formats. Any icon-set conditional formatting generated by Copilot and saved in an .xlsx file will display correctly and remain fully editable when opened in WPS Spreadsheet.