Multiple Conditional Formatting with Copilot in Excel

In this video I put Copilot to the test in Excel by giving it three Conditional Formatting tasks in the same prompt. I ask Copilot to highlight three different items, each in a different colour and then check the Conditional Formatting tab to see what rules it created for me.
Step-by-Step Guide for Using Co-Pilot for Conditional Formatting
Have you ever looked at a spreadsheet and thought, "This data could really stand out with some color"? That's where conditional formatting comes in, and with Excel's CoPilot, it's easier than ever. I'll walk you through how I use CoPilot to apply conditional formatting to my data. It's like having an assistant do the tedious work for you.
1. Identify Your Data Range
First, you need to know which part of your spreadsheet needs conditional formatting. For me, it was column F. This column contained various sources of data, and I wanted to visually differentiate them with colors.
2. Decide on Your Conditions and Colors
Next, decide on the conditions and the corresponding colors you want to apply. My goal was to highlight data from different sources in different colors. Specifically, I wanted:
• Anything marked as "Meta" to be yellow,
• Anything from "LinkedIn" to be green, and
• Any "Magazine" entries to be orange.
Your conditions will depend on your specific data needs.
3. Activating CoPilot
With your conditions ready, it's time to bring in CoPilot. Click into your data and pull up CoPilot. For me, it was as simple as clicking into a cell within column F and then activating CoPilot.
4. Giving Instructions to CoPilot
Here's where you get specific. I told CoPilot, "For column F, using background colors, make Meta yellow, LinkedIn green, and Magazine orange." The trick is to be clear about your conditions and desired outcomes. CoPilot is smart, but it follows your commands, so clarity is key.
5. Let Co-Pilot Do Its Magic
After sending my command, CoPilot got to work. In a moment, it applied the conditional formatting rules across column F, exactly as I had instructed. The best part? CoPilot confirmed its actions, telling me it was "done" and even showing exactly what it had applied. This feedback is great for peace of mind.
Blog Post chrismenardtra...
Please Like this video and make sure you subscribe to my channel!
- EQUIPMENT USED --------------------------------
○ My camera - amzn.to/3vdgF5E
○ Microphone - amzn.to/3gphDXh
○ Camera tripod - amzn.to/3veN6Rg
○ Studio lights - amzn.to/3vaxyy5
○ Dual monitor mount stand - amzn.to/3vbZSjJ
○ Web camera - amzn.to/2Tg75Sn
○ Shock mount - amzn.to/3g96FGj
○ Boom Arm - amzn.to/3g8cNi6
- SOFTWARE USED --------------------------------
○ Screen recording - Camtasia - chrismenardtra...
○ Screenshots - Snagit - chrismenardtra...
○ CZcams keyword search - TubeBuddy - www.tubebuddy....
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!

[@ChrisMenardTraining]

All my online courses are available at courses.chrismenardtraining.com Blog post chrismenardtraining.com/post/using-co-pilot-in-excel-for-conditional-formatting-a-step-by-step-guide