From the course: Copilot for Excel: Achieve More with Your AI Assistant by Microsoft Press

Unlock this course with a free trial

Join today to access over 25,500 courses taught by industry experts.

Manage conditional formatting rules

Manage conditional formatting rules

From the course: Copilot for Excel: Achieve More with Your AI Assistant by Microsoft Press

Start my 1-month free trial Buy for my team

Manage conditional formatting rules

“

- [Instructor] In this lesson, we are going to look at managing your conditional formatting rules, what Copilot is capable of and what it is not, and how we can work around that. So let me begin by popping in this prompt in the Copilot's pane to highlight the top five values of the this year column. And that will work just as we suspected, because I showed that example in the first conditional format in video of this course, but I did not specify a color. So we have that default yellow just like in the previous lesson. Now at this point, I could look to review that. I could put in another prompt and instruct it that could I have it with whichever color I wanted. But if I click apply, then now that rule is applied to the grid and it's too late for me to review and edit that prompt. So the question would be, can I get Copilots to edit the conditional formatting rule itself? So I've now got a prompt in there asking to change the color of the previous rule to use a lighter green. And you…

Contents