Excel Data AnalysisLesson 38Free preview
Excel Highlight Cell Rules
This lesson is part of Excel · All levels
Summary
Highlight Cell Rules are a category of Conditional Formatting that compares the value of a cell to a specific metric, such as Greater Than, Between, Equal To, or Text that Contains. There's also a Duplicate Values rule for marking twin data. This rule is most often used for rapid audits of sales, value, and inventory data.
Key points
- Popular rule: Greater Than, Less Than, Between, Equal To
- Text that Contains filter based on text snippets
- Duplicate Values mark cells with twin values
- Compare the numbers or text you specify
Full lesson
Code examples and quizzes
Full lessons, code examples, and quizzes are available to subscribers. 5 questions.