Multiple criterias to be highlighted using table tool

Question

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 Answer

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 Answer

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 😀👍