See how to apply conditional formatting across an entire row of data. Although not available via menu choices, you can use a conditional formatting rule based on a formula to create this effect.
- [Instructor] In this worksheet called Format Rows,…we'd like to apply conditional formatting…to the numbers in column G, for all those…over 15,000 like these two here,…we want them to have a green background.…A common question about conditional formatting is…can we have the other cells within the same row…and within the list also have the green color?…It's going to be easier to read as we eventually…scroll up and down to look at our data here.…We can do that and it's not difficult but it certainly…isn't obvious how to do this.…A quick reminder as to how I might do this in a…quick standard way, we'll select column G,…Go to Conditional Formatting, Highlight Cell Rules,…Greater Than, and we'll make it be 15,000.…
And if that color combination is good enough for us,…we'll just stick with it.…We certainly see immediately what's happening.…But let's imagine we want the cells to the left…to be highlighted as well.…I'm going to press Control + Z to undo the previous action…of applying conditional formatting.…And now, I'm going to select all the columns…
LinkedIn Learning (Lynda.com) is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Conditional formatting based on content
- Formatting based on formulas
- Using data bars to display length or volume
- Using color scales to display relative differences
- Highlighting PivotTable results
- Applying banded rows