For a date column, you can apply formatting based on the date being "in the past" or "in the next days" (among other options). For example, for a Checkbox column, you can apply formatting based on whether the box is checked. The available criteria will vary depending on the column type.The condition you set determines what will trigger the formatting. For example, if you'd like to apply a background color to all rows assigned to Joe, select the column named Assigned To in the left pane and the criteria Joe in the right pane. Click to display the Set Condition window.Click Add New Rule to create a new, blank conditional formatting rule.Click Conditional Formatting on the toolbar to display the Conditional Formatting window.For more information about how to create formulas, see Create and Edit Formulas in Smartsheet.Ĭonditional formatting from linked cells is not preserved in the destination sheet. To change cell values based on criteria, you'll want to use a formula. The conditional formatting feature won't change cell values. Conditional formatting rules apply formatting automatically to rows or cells based on the values they contain.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |