Conditional formatting: how to compare multiple values

in the first row
cat is not the same as values on the left, nor is elephant nor is the first mouse
so why pig ?

and why mouse on 2nd row and not on first

perhaps
Please upload a small clean sample of your data / workbook (not a picture) to the forum, Make sure you have removed any private information, remember this is a public forum and so available to anyone
We would like to see an example of your data and also a manual mock up of the expected results you want to achieve.

To attach a file to your post,
click "Go advanced" (next to quick post),
scroll down until you see "manage Attachments",
click that and select "Choose File" (top Left corner).
Find your file, click "Open" click "upload" click 'close windows" Top Right. click "Submit Reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

Hi,

Thank you for your reply.
My apologies, the two columns in the problem description have been merged and made unclear what I meant.
Attachment 535062

I manually highlighted in red values which are not equal to the values in the same row on the left.

use a conditional format rule
=COUNTIF($A3:$D3,E3)=0
but
why is monkey highlighted in cell f3


for 2007, 2010 , 2013 or 2016 excel version
Conditional Formatting

Highlight applicable range >>

$E$3:$V$11


Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:


=COUNTIF($A3:$D3,E3)=0


Format… [Number, Font, Border, Fill]
choose the format you would like to apply when the condition is true
OK >> OK

=COUNTIF($A3:$D3,E3)=0
false
as shown on the sample i attached

=COUNTIF($A3:$D3,E3)>0 or =COUNTIF($A3:$D3,E3)
true