Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Conditional Formatting

May Kim
May Kim
edited 12/09/19 in Archived 2015 Posts

How can I apply conditional formatting to the entire sheet? Some rows will automatically update  based on the conditional formatting I set up but others will not.


  • Jim Hook
    Jim Hook ✭✭✭✭✭✭

    Each conditional formatting rule automatically applies to all rows in the sheet even if you would rather have it apply to just some rows. If some rows are apparently not updating with the conditional format it is usually due to something like the condition expecting a number when the row contains text in the cell that is used to set the condition. Another thing to watch out for is if multiple conditional formating rules apply to the same column, only the first one that matches a condition will be executed for that row. You can reorder the sequence the rules are applied by simply dragging and dropping the rules to change the order they are tested in.

This discussion has been closed.