Skip to Content

Conditional formats are a strict rules-based format that allows users to provide logic and the subsequent appearance when the condition from the logic applies.

Conditional formats can be as simple as checking if a value within a certain range is greater than, equal to, or less than a fixed value, or can be complex with Custom Formulas (in Google Sheets).

Conditional formats can enhance the user experience by providing a visual alert to users and to draw their attention where needed to specific cells.