Highlighting Certain Letters

[ajaydhamrait]

Hi All,

I'm trying to highlight one of the fields Yellow on the Excel Output if it doesn't have '4' or '5' (column rule). I've tried the formula: 

[Field] NOT IN ('4',5’)   

But it hasn't worked. Any suggestions?

Thanks!

[messi007]

@ajaydhamrait,

Please see below :

I used the condition on the table tool :

Attached the workflow,

Hope this helps !

Regards,

[OllieClarke · Accepted solution]

@ajaydhamrait 

If you want any occurrence of a 4 or 5 to be unhighlighted, like this:

Then use this formula:

!CONTAINS(Tostring([Field]),'4') 
AND 
!CONTAINS(Tostring([Field]),'5')

Otherwise amend your formula to add a tostring() as IN() requires string data

ToString([Field]) NOT IN('4','5')

Hope that helps,

Ollie