Containing Certain Words

[ajaydhamrait]

Hi All,

I'm trying to highlight the Excel output cell Yellow if the field (in my instance, it's 'Firm Name') contains the words 'LLP' and 'Limited' in the column. I've had no luck unfortunately. 

Thanks!

[DataNath · Accepted solution]

Should be able to just use the following as your highlight condition:

Contains([Firm Name], 'LLP') or Contains([Firm Name], 'Limited')