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

[table="width: 500, class: grid, align: center"]
[tr]
[td]A1000[/td]
[td]Lee[/td]
[td]Steve[/td]
[td]Darren[/td]
[td]Martin[/td]
[td]333[/td]
[td]445[/td]
[/tr]
[tr]
[td]A1001[/td]
[td]Cat[/td]
[td]Dog[/td]
[td]Cat[/td]
[td]Rabbit[/td]
[td]Zebra[/td]
[td]Seahorse[/td]
[/tr]
[tr]
[td]444[/td]
[td]ef[/td]
[td]gfd[/td]
[td]555[/td]
[td]dfsdf[/td]
[td]55[/td]
[td]555[/td]
[/tr]

[tr]
[td]444[/td]
[td]Cat[/td]
[td]gfd[/td]
[td]555[/td]
[td]Cat[/td]
[td]55[/td]
[td]555[/td]
[/tr]

[/table]

 

[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