From the course: Excel: Conditional Formatting for Beginners

Unlock this course with a free trial

Join today to access over 25,600 courses taught by industry experts.

Apply conditional formatting across rows of data

Apply conditional formatting across rows of data - Microsoft Excel Tutorial

From the course: Excel: Conditional Formatting for Beginners

Start my 1-month free trial Buy for my team

Apply conditional formatting across rows of data

“

- [Instructor] We're looking at the worksheet Conditional Formatting across rows in our chapter three file. And the name of this worksheet describes what we're about to consider doing. I'd like to highlight those entries here where the amount over in column G is above 15,000 and the first order of business is likely to be, well, let's look at column G and go to Conditional Formatting. Maybe we'll just apply a color here. Highlight the cell rules greater than, and automatically the default formatting kicks in. We could say, okay, good, but that only highlights the cells in column G. Maybe better if we can highlight the entire row. Now this is not difficult to do, but it certainly isn't obvious and there's no way by way of conditional formatting. As you look at some of the various options under Highlight Cell Rules or Top/Bottom Rules, it actually gives you that capability. So we're actually going to have to create a new rule by way of a formula. So let me undo what I had done here…

Contents