Copilot in Excel: Conditional Formatting with Complex Functions

Copilot in Excel now supports Conditional Formatting with Formulas. This is an awesome feature. For example, Copilot can highlight an entire row where the State is Georgia and the city is Atlanta. In this video, I demonstrate how to highlight any row where the state is Georgia, and the FY24 value is over 1,000 with a yellow background. Copilot handles the entire process, from selecting the data to using the AND function in the Conditional Formatting rule.

After applying the rule, I'll quickly test it by changing a value, and the row instantly updates with a yellow background. I'll also review the Conditional Formatting manager to show the rule that was created.

This is a great Copilot feature. To learn more about Copilot and my online training, feel free to subscribe. And let me know what you think in the comments! And make sure you subscribe to my channel!

Chapters
0:00 Introduction
0:26 Conditional Formatting with Copilot
1:15 Applying the Conditional Formatting Rule
1:41 Recap and Online Training

Microsoft Roadmap
Feature ID: 392454
Added to roadmap: 4/18/2024
Last modified: 7/26/2024
Product(s): Microsoft Copilot (Microsoft 365), Excel
Cloud instance(s): Worldwide (Standard Multi-Tenant)
Platform(s): Web
Release phase(s): General Availability

#copilot #microsoftcopilot #copilotinexcel #excelcopilot #chrismenardtraining

-- EQUIPMENT USED ---------------------------------

-- SOFTWARE USED ---------------------------------

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!