Discover how to base a conditional formatting rule on the content of a specific cell and use a data validation list to change that cell quickly without typing.
- [Instructor] In this worksheet called Data Val…and conditional formatting, those are abbreviated,…we've got a list from columns A through I.…And although we could be using a filter here…to just show some of the data,…what we'd like to be able to do…is type an entry, for example in cell K2.…And if I were to type in ADC for example,…just highlight the rows where that is the department.…For example, row 14 here with Rob Anthony,…down here with Polly in row 21.…We want to highlight those based on the content of cell K2.…
So it's not uncommon to base conditional formatting…on the content of an external cell.…And if we want to highlight all the cells across,…the row within this data,…let's begin by selecting columns A through I.…Go to conditional formatting,…we're going to establish a new rule.…And use a form that is to determine which cells to format.…Now the form is going to be based on…what's happening in column C.…It's always going to be in column C.…So our formula begins with equal dollar sign C.…
The dollar sign sign meaning…
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