SOLVED
Column rules - conditional format with several conditions - Table tool
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Luciano-ip
6 - Meteoroid
‎04-21-2023
12:27 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi! I am trying to format a column to color the cells as follows but I end up with all green results... I just cannot get to the correct formula to take into account the other 2 previous conditions.
For the green format I was using the following formula: !contains([Field1],"Wrong") or !contains([field1],"Check")
Red: if it contains the word "Wrong"
Orange: if it contains the word "Check"
Green: If it does not contain any of the above mentioned words (Wrong or check)
Thanks in advance!
Solved! Go to Solution.
Labels:
- Labels:
- Best Practices
3 REPLIES 3
16 - Nebula
‎04-21-2023
12:34 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I think you want "and",
!contains([Field1],"Wrong") and !contains([field1],"Check")
Green if Field1 is not "wrong" AND Field1 is not "check.
Alternatively,
not (contains([Field1],"Wrong") or contains([field1],"Check"))
MilindG
12 - Quasar
‎04-21-2023
12:37 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎04-21-2023
12:48 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks!! it worked perfectly.
