From the course: Excel 2016: Tips and Tricks

Unlock the full course today

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

Add a color background to every 5th row in a range

Add a color background to every 5th row in a range

From the course: Excel 2016: Tips and Tricks

Start my 1-month free trial

Add a color background to every 5th row in a range

“

- [Voiceover] If we use this list often on the screen and also on the printed page, it might easier to read if every other row were a different color or every fifth row, something like that, every tenth row. We can do this in a few ways. First of all, if you do convert data to a table, now you might not be familiar with that feature, but if you work with lists of data and the list grows and shrinks, and you frequently need to sort the data, filter the data and treat it as a unit, you can convert data to a table. Let's hold that thought for a minute and simply work with data that's not a table. This is not a table. We might want to have every fifth row highlighted differently so we can read it. And there's another worksheet over here called Scientific. Pretty boring data, and I don't understand it, but I might want to look at this too, and have the same feature in effect. And it doesn't have to be five rows. It could be four, three, 10, whatever. We can change it. Let's go back to that…

Contents