Table With Conditional Formats and Data Validation

Spread supports automatically adding any existing conditional formatting and data validation rules to newly added table rows or columns.

In the following example, tables columns B:F have data validation rules. Column F also has conditional formatting rules. Click in cell F11 (value ‘13’) and press the Tab key. A new row will be added. You can follow the rules in the above rows to see this in action. For example, in B12, type ‘5’. This is not a valid value so it will be highlighted. Type ‘10’ in F12 to highlight is using the conditional formatting rules.