Multiple criterias to be highlighted using table tool

[hegdepavithra10]

Hi ,

I have the following data

I want the table tool to color only when the value under column A is "Not valid","Not match", "Threshold breach". However by using the below formula under column rule, the entire column irrespective of the value is getting colored red.

if [A] = "Not valid" OR "Not match" OR "Threshold breach" then "color:red;" else null() endif

[Jonathan-Sherman · Accepted solution]

Hi @hegdepavithra10,

You could use a row rule in the table tool for this:

I always prefer to use the IN() function to list strings as I find it makes it easier personally.

[A] IN('Not valid','Not match','Threshold breach')

The output you get looks like:

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

[atcodedog05 · Accepted solution]

Hi @hegdepavithra10 

Here is the column rule

[A] in ("Not Valid","Not Match","Threshold breach")

Output:

Edit : same as @Jonathan-Sherman posted around seconds difference 😅

Hope this helps 🙂 Feel to ask if you have any questions

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[Jonathan-Sherman]

I would also note @hegdepavithra10 that you could use a column rule or a row rule (both a similar approach to setting up, same formula etc) the difference is a row rule will apply the conditional formatting to the whole row (all columns) and a column rule only to the applied column.

Row Rule:

Column Rule:

Regards,

Jonathan

[Jonathan-Sherman]

Seems you've got the best of both worlds on this post as @atcodedog05 talks about a column rule and I showed the row rule approach! One of the wonders of the Alteryx Community!