From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 23,200 courses taught by industry experts.

Apply conditional formatting across data rows

Apply conditional formatting across data rows - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Apply conditional formatting across data rows

“

- [Instructor] On this worksheet, we're seeing three different images of different worksheets, and they all have in common a feature referred to as banded rows. On the left side, we see a table. When you create a table in Excel, the banded row feature kicks in automatically. You do have the alternative of using banded columns instead. In the middle, we see a list here with yellow rows. And here we're using a feature called conditional formatting. And the rows are yellow simply for readability purposes. So as we scroll back and forth, left and right, it's easier to follow the data. We could just as easily have done this with every fourth row or every third row or every other row. Variety of different schemes could be available by way of conditional formatting. And in the image to the right where we see the green rows, we're using conditional formatting here to highlight only the rows where the employees…

Contents