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.
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"))
Thanks!! it worked perfectly.