Add a Conditional Format Rule

What this operation supports in Google Sheets

Adds a conditional formatting rule to a range, applying visual formatting automatically whenever a cell matches the rule's condition.

Implementation details

The rule is evaluated live against the target range going forward -- it doesn't retroactively change how past, already-rendered views of the sheet looked before the rule existed.

Operational considerations

Because rules are evaluated in a defined priority order when more than one could apply to the same cell, adding a new rule without checking existing ones can produce an unexpected formatting result if they conflict.

Automatically highlight outliers in a weekly sales sheet to draw attention during reviews.

1. Flag overdue tasks in a project tracker by color-coding based on due date gaps.
2. Emphasize variance beyond a threshold in a financial report.
3. Color cells containing missing data to guide data cleaning in Google Sheets.
4. Differentiate multiple status values in a status dashboard.
5. Highlight top-performing regions in a performance sheet.
6. Indicate when values deviate from a baseline in operational metrics.
7. Notify collaborators visually when critical conditions appear in data streams.