Apply Conditional Format to Numbers only for a Column with both Integers and String value

[dhruvb]

Hi,

I am trying to apply Conditional format to a column which is in V_W String format as it contains both String and Integer values. 

I want to apply the conditional format only to the numbers and not the Sting value (Eg: Do not ant to apply on Sting value "Above 100")

Formatting required is >50 cell color red. 50-100 cell color Green.

[Jonathan-Sherman]

Hi @dhruvb,

You could use the table tool for this and create two conditional column rules:

Red: ToNumber([Column1]) < 50 AND Regex_Match([Column1], '[0-9.]+')

Green: ToNumber([Column1]) >= 50 AND Regex_Match([Column1], '[0-9.]+')

Result:

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

[dhruvb]

Thank you Jonathan for the solution. 

If my column keeps changing and I want to add this conditional format to any Dynamic columns added in future, How can I do that?

[Jonathan-Sherman · Accepted solution]

Hi @dhruvb,

Creating Column Rules on "Dynamic or Unknown" fields (ensure it's ticked) will apply this formatting to any new columns.

Red: ToNumber([_CurrentField_]) < 50 AND Regex_Match([_CurrentField_], '[0-9.]+')

Green: ToNumber([_CurrentField_]) >= 50 AND Regex_Match([_CurrentField_], '[0-9.]+')

If this solves your issue please mark the answer as correct, if not let me know!

Regards,

Jonathan