Remove conditional formatting from rows
Hi,
Just wondering how to remove conditional formatting from specific rows. I am fairly new to using smartsheet but it seems like you can only do conditional formattings to certain columns but what if you wanted specific rows to not have the rules?
Answers
-
Hi @Tina Truong
Would you be able to provide a little more information, for example a screen capture of how your sheet is set up & what rows you want excluded (but please block out any sensitive data!).
You would want to adjust the criteria for the Conditional Formatting so that it doesn't include these rows in, perhaps by adding in an AND statement.
So, for this example, I want certain cells to turn red but only if there's a red status ball in one column AND if there's a checkbox in another:
I added in the AND statement by clicking on the dropdown arrow on the left and selecting "Add Condition (And)"
You can learn more about Conditional Formatting in our Help Center (see here).
I hope that helps!
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives