Conditional Formatting
Conditional Formatting helps you automatically change cell display styles based on rules so teams can quickly identify key information in shared data. It provides the tools you need to highlight values and visualize patterns more efficiently. With Conditional Formatting, you can apply preset rules such as greater than, less than, between, equal to, text contains, dates, duplicate values, top or bottom values, above or below average, data bars, color scales, and icon sets, or create custom rules using values or formulas. You can also edit existing rules, change rule priority to control which format appears when multiple conditions are met, and clear rules from a selected range or an entire worksheet. Whether you're reviewing shared worksheets or maintaining consistent formatting for collaborators, Conditional Formatting helps you stay productive and complete tasks efficiently across different devices and work environments. Choose the documentation below that best matches your needs to learn more.