Column rules - conditional format with several conditions - Table tool

[Luciano-ip]

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!

[PhilipMannering · Accepted 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"))

[MilindG]

@Luciano-ip

[Luciano-ip]

Thanks!! it worked perfectly.