From the course: Copilot for Microsoft 365: Boosting Productivity in Excel, Word, PowerPoint, Outlook, and Teams

Unlock the full course today

Join today to access over 24,600 courses taught by industry experts.

Highlight cells: Conditional formatting

Highlight cells: Conditional formatting

From the course: Copilot for Microsoft 365: Boosting Productivity in Excel, Word, PowerPoint, Outlook, and Teams

Start my 1-month free trial Buy for my team

Highlight cells: Conditional formatting

“

- Picture this, an Excel spreadsheet that instantly highlights trends, outliers, and key data points, making complex information pop right off the screen. No more scanning through rows of data to find what matters. Instead, harness the power of Copilot with Excel's conditional formatting to make highlighting data a breeze. Conditional formatting in Excel allows us to apply formatting to cells based on specific criteria. For example, maybe I want to highlight all cells where the units sold are greater than or equal to a thousand. Or maybe I want to highlight all rows where the sales channel is online. We can get Copilot to help us with this. So let's start out in our data set by highlighting all the sales in the total sales column where the sales value is greater than or equal to 60,000. Let's launch Copilot from the Home ribbon and type in our prompt. "Highlight in the total sales column all values that are greater than or equal to 60,000." And I want those highlighted with a light…

Contents