Conditional Formatting

Conditional Formatting helps you automatically change cell display styles based on rules you set. It provides the tools you need to highlight data, mark exceptions, and visualize values more clearly, making your work more efficient and helping you accomplish tasks with ease. With Conditional Formatting, you can apply preset rules such as greater than, less than, between, equal to, text contains, date occurred, duplicate values, top or bottom rankings, above or below average, data bars, color scales, and icon sets, or create custom rules with values or formulas and custom formatting. You can also view, edit, prioritize, add, and clear rules for a selected range or an entire worksheet. Whether you're highlighting key data or managing multiple matching rules, Conditional Formatting helps you stay productive. Choose the documentation below that best matches your needs to learn more.

1:53