Learn how you can highlight all conditional formatting cells in a worksheet via the Find & Select button or highlight just the cells with the same formatting rules as the current cell.
- [Instructor] Most of the time when conditional formatting…is being used in a worksheet, you see it.…It's obvious.…In this worksheet called format rows,…there appears to be no conditional formatting in place.…But there is other data off to the right.…Eventually we discover it and sure enough over there,…it looks like the same.…But in any worksheet, at any time, if you want to know…and track down where conditional formatting might be,…click on any cell.…And you would think that we go to conditional formatting,…but there's nothing really here that helps us…track down existing conditional formatting.…
However, on the home tab, in the ribbon, far right button,…find and select, we see conditional formatting.…And that highlights all the cells in this worksheet.…Now, are there any off to the left?…Doesn't look like it.…But, there's some right here.…And we see how it exists.…Now, there's conditional formatting in column R, column S.…Often, but not always, conditional formatting…is for a single column.…But, if you click on a cell, you can track down…
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