Column rules - conditional format with several conditions - Table tool

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!

Best Practices

Accepted answers

philipmannering

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"))

All comments

philipmannering

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

@Luciano-ip

Luciano-ip

Thanks!! it worked perfectly.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703