Hi all,

I have a worksheet with 6 columns A:F
I need to highlight duplicate values per row across the six cells even if values aren't contiguous.
In my search for a solution I found this formula for a conditional formatting that selects numbers only:
=AND(ISNUMBER(A1), COUNTIF(1:1,A1)>1)
Any assistance with this urgent request is truly appreciated.

Thanks in advance.
T.