From the course: Excel 2016: Advanced Formatting Techniques

Unlock the full course today

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

Create formats based on formulas

Create formats based on formulas

From the course: Excel 2016: Advanced Formatting Techniques

Start my 1-month free trial

Create formats based on formulas

“

- Sometimes, when you work with conditional formatting, you'll need to actually write formulas to have the conditional formatting do its job. We're on a worksheet called, and I've abbreviated it, conditional formatting formulas. A common question I hear about conditional formatting is why isn't there a way or is there a way to highlight the entire row when a condition is true? So rather than just having the five highlighted here, we want to have standout all those people whose performance level is a five. Let's highlight the entire row here instead of just that cell here. Now this is easily applied. All I need to do is click column F, conditional formatting. One of the simple ways of simply saying if the cell is equal to five, give it a color. That's been done, but let's get rid of that. Click column F, Conditional Formatting, clear the rules from the selected cells. Now let's imagine that if we want formatting to exist all the way across the cells, then we want to be selecting data…

Contents