Conditional Formatting

[mfranchino21]

Hi all, 

I have a table, and lets say it looks like this:

 Car               Code

 Ford             7011

Chevy           7011

Toyota           8956

Honda           7011

Fiat                6589

Jeep              1818

I would like to highlight each cell or row that isnt 7011 or 1818. With that said, I dont know all the inputs and outputs, all I know is that anything that isnt 7011 or 1818, I would like to be highlighted.

Im using the basic table. 

Thanks!

[binuacs · Accepted solution]

@mfranchino21 make the below formula change in the table row rule

!Contains(toString([Code]),'7011') AND !contains(toString([Code]),'2342')