Excel Data AnalysisLesson 37Free preview

Excel Conditional Format

This lesson is part of Excel · All levels

Summary

Conditional Formatting automatically changes the appearance of the cell based on certain conditions, for example marking a value below 60 in red. Because the format follows the values, the display will adjust itself as the data changes. This feature is available in the Home > Conditional Formatting tab and includes many categories of ready-made rules.

Key points

Automatic format follows a certain value or formula condition
It's at Home > Conditional Formatting
Suitable for marking critical, duplicate, and targeted numbers
The format adjusts itself as the data changes

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.