Hi,

I need to compare multiple values ( 20 columns of 100 rows) with four columns and need to highlight values, which are not equal to the values located in the same row in those 4 columns. Each value may be equal to one of the values in the row on the left. If not it needs to say: WRONG or to be highlighted

Example:

Correct values Values which need to be compared
Dog Cat Elephant Mouse Mouse Pig Cat
Dog Cat Horse Mouse Dog Cat Horse
Dog Cat Horse Mouse Fish Pig Dog
Dog Cat Dog Mouse Mouse Pig Cat
Dog Cat Horse Mouse Mouse Pig Dog
Dog Cat Horse Mouse Pig Dog Pig

In the first row "Pig" needs to be highlighted because it is not among the values listed in the same row on the left.
In the second row "Mouse" needs to be highlighted because it is not among the values listed in the same row on the left.