From the course: Cert Prep: Excel Expert - Microsoft Office Specialist for Office 2019 and Office 365

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Solution: Manage and format data

Solution: Manage and format data

From the course: Cert Prep: Excel Expert - Microsoft Office Specialist for Office 2019 and Office 365

Start my 1-month free trial

Solution: Manage and format data

“

(upbeat electronic music) - [Instructor] Welcome to the solution video for the chapter three challenge. For this challenge, we used the 03_09 challenge exercise file and I challenged you to complete all the tasks in 12 minutes or less. Let's get started. First we'll save the file as my challenge in our chapter three folder. File, save as, my challenge and save. Number two, complete the task on the project one, two, and three worksheets. Let's go to project one. Display CSR in blue text. I'll click in C9, Control + Shift + Down Arrow will select that entire range very quickly for me. We'll go to conditional formatting, highlight cells rules, text that contains, CSR, and let's go to custom format. We want the font to be blue. Let's make sure that everything else is cleared out. Oh, we've got some pink in the background. Let's clear that, and click okay, and okay, and that step is done. Let's go back up…

Contents