Microsoft will update Copilot in Excel to support formula conditional formatting

The new options will be released in May 2024.

2 min. read

Published onApril 19, 2024

published onApril 19, 2024

Share this article

Read our disclosure page to find out how can you help Windows Report sustain the editorial teamRead more

The Redmond-based tech giant first released Copilot in Excel last year, but initially, the AI model was capable of simple tasks, such as summarising and editing information in there. However, gradually Microsoft updated it to support different formulas.

For instance, a while ago it introduced two new complex formulasto manage multiple tables, and it also got the abilityto generate multiple formula columnsfrom a single prompt.

According to the latest entry in theMicrosoft 365 Roadmap, Copilot in Excel will also be soon capable of formula conditional formatting. This will allow the AI model to handle complex tasks, meaning users won’t be alone in handling such tasks anymore, as Copilot can be of assistance.

Additional support for complex conditional formats beyond the basic top and bottom or conditional operators. For example, Copilot analyzes two factors when highlighting all rows where the product is bikes and sales is greater than 100.

The new formula conditional formatting enhancements will be released to Copilot in Excel in May 2024, and those dealing with a lot of Excel information on a daily basis, at their work, should use it.

Why? It could greatly streamline workflows and enhance productivity, as the AI model can extract information from different Excel documents and analyze and process them using the formatting options. The good thing about Copilot is that the AI model is a unified experience meaning it should, theoretically, understand and extract information from different documents.

This makes it a valuable tool to use: it reduces time and provides a relatively stress-free experience with dealing with detailed information such as Excel data.

With KB5043178 to Release Preview Channel, Microsoft advises Windows 11 users to plug in when the battery is low#

Copilot in Outlook will generate personalized themes for you to customize the app#

Microsoft will raise the price of its 365 Suite to include AI capabilities#

Death Stranding Director’s Cut is now Xbox X|S at a huge discount#

Outlook will let users create custom account icons so they can tell their accounts apart easier#

Microsoft will update Copilot in Excel to support formula conditional formatting#

With KB5043178 to Release Preview Channel, Microsoft advises Windows 11 users to plug in when the battery is low

Copilot in Outlook will generate personalized themes for you to customize the app

Microsoft will raise the price of its 365 Suite to include AI capabilities

Death Stranding Director’s Cut is now Xbox X|S at a huge discount

Outlook will let users create custom account icons so they can tell their accounts apart easier

Microsoft will update Copilot in Excel to support formula conditional formatting