In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Column rules - conditional format with several conditions - Table tool

Luciano-ip
6 - Meteoroid

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!

3 REPLIES 3
PhilipMannering
16 - Nebula
16 - Nebula

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
Luciano-ip
6 - Meteoroid

Thanks!! it worked perfectly.

Labels
Top Solution Authors