Highlight 1st Duplicate in Row

[antialias401]

Hi Everyone,

I've searched to no avail.

I would like to highlight the 1st Duplicate Inside a Same Row:

A	B	C	D	E	F
100	100	100	250	250	250

<tbody>
</tbody>

VBA to do this would be Ideal, but I can also live with a Conditional Formatting formula.
=AND(COUNTIF($A1,$A:$A)>1 works on Columns, but I can't mod it to a row.

Any thoughts??
Thanks, I appreciate this forum greatly!

 

[JoeMo]

For row 1 try this CF rule, set format to red font.

=AND(COUNTIF($1:$1,A$1)>1,COUNTIF($A$1:A1,A1)=1)