Conditional formatting in Rows lets you automatically style cells based on their values. This is useful for quickly spotting trends, flagging issues, or just making your data more readable.
How to Apply Conditional Formatting
- Select the range you want to format.
- From the format bar, go to Styles > Conditional formatting
- Choose a condition from the If cell value dropdown and enter a value (if required)
- Select the text and background color options from the preset or click on the + icon to choose custom colors
- Finally, click on the Add rule button
Available Conditions
| Type | Condition | Values |
|---|---|---|
| Value-based | is not empty is empty | N/A |
| Text-based | text contains text does not contain text starts with text ends with text is exactly | String |
| Date-based | date is date is before date is after | today yesterday tomorrow in the past week in the past month in the past year exact date |
| Number-based | is greater than is greater than or equal to is equal to is not equal to is less than is less than or equal to | Number |
How to Edit or Remove Rules
Navigate to the conditional formatting panel and click the condition to edit it or the bin icon to remove the rule —
Tips
- You can combine multiple rules to handle different scenarios in the same column (e.g. red for overdue, green for completed).
- Rows applies rules from top to bottom and only the first matching rule is applied.
- To change which rule takes precedence, simply drag and reorder the rules in the Conditional Formatting panel.
