highlight_where
Apply conditional highlighting to cells in Google Sheets using natural language conditions like '> 100' or 'contains overdue'. Set background color, text color, or bold.
Instructions
Conditionally highlight cells from a natural predicate.
condition examples: "> 100", "between 10 and 20",
"contains overdue", "blank", "duplicates", "top 10%".
Applies the given background color (default light amber), and/or
text_color/bold. range accepts A1 or natural refs.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| bold | No | ||
| color | No | ||
| range | Yes | ||
| condition | Yes | ||
| text_color | No | ||
| spreadsheet | Yes |