Greetings, We’re continuing our series of posts to show you some of the things that are possible to do with Copilot in Excel. Today I will show you how Copilot can help add icons to better visualize results. I will start with some result data:

Table including 3 columns, including ID, Results (#), and Results (%)

To add the icons I will ask Copilot: Add an icon set to both results columns

Copilot in Excel pane showing the above prompt and a response for a conditional formatting rule to review and apply, with a button to apply the conditional formatting.

OK! Looking at B2:D23, here are 2 conditional formatting rules to review and apply:

Icon Set: Apply an icon set rule on C3:C23

3 Arrows

Icon Set: Apply an icon set rule on D3:D23

3 Arrows

I click on the apply button and get the following result:

Results table with Green, Yellow and Red arrows indicating the magnitude of the values in the results columns.

Over the coming weeks I will be sharing more examples of what you can do with Copilot in Excel.

Thanks for reading,

Microsoft Excel Team

*Disclaimer: If you try these types of prompts and they do not work as expected, it is most likely due to our gradual feature rollout process. Please try again in a few weeks.

​Greetings, We’re continuing our series of posts to show you some of the things that are possible to do with Copilot in Excel. Today I will show you how Copilot can help add icons to better visualize results. I will start with some result data:
 
Table including 3 columns, including ID, Results (#), and Results (%)
 
To add the icons I will ask Copilot: Add an icon set to both results columns
 
Copilot in Excel pane showing the above prompt and a response for a conditional formatting rule to review and apply, with a button to apply the conditional formatting.
 
OK! Looking at B2:D23, here are 2 conditional formatting rules to review and apply:

Icon Set: Apply an icon set rule on C3:C23

3 Arrows

Icon Set: Apply an icon set rule on D3:D23

3 Arrows

I click on the apply button and get the following result:
 
Results table with Green, Yellow and Red arrows indicating the magnitude of the values in the results columns.
 
Over the coming weeks I will be sharing more examples of what you can do with Copilot in Excel.
 
Thanks for reading,
Microsoft Excel Team
 
*Disclaimer: If you try these types of prompts and they do not work as expected, it is most likely due to our gradual feature rollout process. Please try again in a few weeks.
 
   Read More

​