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.
Is there an "OR" condition in conditional formatting?

I'm a very new user (1 week) and I am trying to apply conditional formatting if any one of 4 conditions is met. I need an OR statement but can't figure out how to do it, other than to do a separate rule for each condition. I searched the community and help and couldn't find anything about OR conditions.
Β
Thanks!
Comments
-
Hello Megret,
Β
Conditional Formatting doesn't currently have an OR option (only the AND option). To accomplish this, you'll need to create four separate rulesβone for each of your conditions. You can duplicate a rule by right-clicking on it.
Β
More on conditional formatting can be found in our Help Center:Β https://help.smartsheet.com/articles/516359-conditional-formatting
-
Hi,
Is there a OR function implementation on the horizon?
I have 6 columns of which all six can have a possibilityΒ of 6 statuses and need 6 colors per status. Β Writing 36 conditional rules will be very time consuming.
Where an OR function will be so much better to use.
Please let me know.
-
Yovanka - have you gotten a resolution to this?Β We're trying to use an OR function now with conditional formatting and having no luck.