Highlight indivudual cells in ROW if same value

[surkdidat]

Is it possible to highlight duplicate cells in ROWS only whereby any text or numeric value is highlighted?

So in the below table

Row 1 - nothing highlighted
Row 2 - Cat highlighted
Row 3 = 555 highlighted (ignores 55)
Row 4 = Both Cat and 555 highlighted

A1000	Lee	Steve	Darren	Martin	333	445
A1001	Cat	Dog	Cat	Rabbit	Zebra	Seahorse
444	ef	gfd	555	dfsdf	55	555
444	Cat	gfd	555	Cat	55	555

 

[FormR]

Hi, you could use conditional formatting - with the "Use a formula" method you could try, for example.

=COUNTIFS($A1:$G1,A1)>1

 

[surkdidat]

Thank you that works perfectly

Hi, you could use conditional formatting - with the "Use a formula" method you could try, for example.

=COUNTIFS($A1:$G1,A1)>1

 

[Jsejms]

Hey guys,

Is there a easy solution to add into this to ignore duplicates in the form of "RDO"?
So all duplicates highlight except RDO.

Thanks