Copilot - Apply Conditional Formatting in Excel

Conditional formatting is a powerful way to visually highlight important patterns in your Excel data, but setting up multiple rules manually can be time-consuming and complex. In this lesson, you'll learn how to use Copilot to instantly create and manage conditional formatting rules using simple language prompts. You'll see how Copilot can highlight entire rows based on conditions such as payment method or customer region, apply visual styles like colour fills and data bars, and even adjust number and date formatting. This approach removes the need to build complex formulas, making it faster and easier to visually analyse your data.