Highlighting Cells If Contains Alphabets

[ajaydhamrait]

Hi,

If a field (in my example it is 'Inception') containing numeric values has a letter somewhere in the value, is it possible to highlight the output cell Yellow?  Currently, I have done this but no luck. 

Thanks!

[DataNath]

I think the following should do the trick:

REGEX_CountMatches([Inception], "[\D]") > 0

This will highlight everything with at least one instance of something that isn't a number in the field. If you need it to be specific to letters then you could use:

REGEX_CountMatches([Inception], "[a-zA-Z]") > 0

[binuacs]

@ajaydhamrait one way of dong this with the help of the RegeEx formula

[ajaydhamrait]

That's amazing, what about the other way round? So if a field containing letters has a number somewhere in the value

[binuacs]

@ajaydhamrait The same formula should work in either case

[DataNath · Accepted solution]

In the formula I provided previously, the \D capitalised indicates a non-number, so if you want to find where there ARE numbers, simply use the lowercase equivalent I.e. \d, which indicates the presence of a number in the field.

[ajaydhamrait]

This is all great! However, I have blank cells in my data that will need to stay there but I don't want these highlighted Yellow (with the above formulas, they highlight them). Is there a way to not highlight blank cells? 

[DataNath · Accepted solution]

If you want to leave empty cells out of the highlight then should just be able to add the following to your highlight condition:

AND !IsEmpty([Field Name])