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](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
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.
Comments
-
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.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives