Learn how to use Highlight Cell Rules options to conduct common data tests, like testing to see if data is greater than, less than, or equal to, specific values or content.
- [Instructor] With Excel's conditional…formatting capability, you can easily make data stand out.…On this worksheet called highlight cell rules…in the file called chapter one,…we're about to use conditional formatting in column E.…We simply want to know those people who have been here…more than 14 years or 15 or greater…is another way to say it.…Many times when using conditional formatting,…you will want to apply the feature to an entire column.…When you work with large lists like this one…that makes perfect sense.…This list might grow or shrink, so when we select…column E, we're about to set up…a conditional formatting rule that will apply…to cells even those that are empty below…because later they might have data in them.…
The conditional formatting feature is found on the Home tab…and its very first option highlight cell rules…will meet a lot of people's needs.…We simply want to indicate those cells here…that are greater than even though…Excel is putting in the number 10 here.…We'll put in the number 14, so 15 and higher.…
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