Finding duplicate values in rows

[fitkhan]

Hi,
Thanks for checking my post... I have an excel sheet It has data in 6 columns and I want to highlight or mark any value that appears twice in the same ROW.... I have highlighted the duplicate values in rows in the sample excel sheet. I shall be very thankful if someone solves this problem...
Thanks in Advance.

[zbor]

Use this for CF criteria:

Please Login or Register  to view this content.

[fitkhan]

Use this for CF criteria:

Please Login or Register  to view this content.

Thanks a lot zbor.. Your formula has solved my problem...