From the course: Excel Power User Challenge

Unlock this course with a free trial

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

Highlight every fifth person in the list

Highlight every fifth person in the list - Microsoft Excel Tutorial

From the course: Excel Power User Challenge

Start my 1-month free trial Buy for my team

Highlight every fifth person in the list

“

- [Instructor] Here's a list of participants, and the objective is to use conditional formatting to highlight every fifth name. We don't want to start with Maude Horton as one, then Kenny two, Morgana three, Jason four, Sasha five, and then highlight Sasha and then count another five and then highlight the next fifth person. No, we want to start with Maude as the first name that conditional formatting highlights and then every fifth person down this column. And let's look how long this column is. Okay. All the way down to Lance. Scroll back up. All right, so that is the challenge. Highlight every fifth name, starting with Maude, and you get to pick the flavor of conditional formatting that you prefer. Go ahead, pause the video, get it taken care of, then come on back. (mellow music) Welcome back. Here is how I'm going to start. Cursor in data set. I'm going to format it as a table. I'm going to format it…

Contents