Highlighting duplicate cells within a row

[Jtec75]

I work with a spreadsheet that has hundreds of rows and numerous columns. Sometimes I accidentally duplicate the same number in more than 1 cell in a row. I know how to use conditional Formatting to highlight duplicates across a range of columns, but need to just highlight the duplicates in a row (for all the rows). E.G:

Row 1: 03,45,22,50,45,60
Row 2: 55,12,08,55
Etc...

As you can see, in Row 1, I've got the number '45' in twice, so would like to highlight this row as having a duplicate. The same for row 2 with the number '55'.

I usually have around 800 rows and 20 columns, so doing each row individually isn't an option. I'm sure there must be a way.
Thanks for your help!

[Special-K]

20 columns, so I assume columns A:T, adjust the formula if to reflect your data.
Select the entire table
Use Conditional Formatting
Use a formula to determine...

=COUNTIF($A1:$T1,A1)>1

[CRIMEDOG]

That is what (basically) I was trying - but that will return the highlight if there is a duplicate in the WHOLE range not just the ROW
So - in the example if there was one 45 on row 2 it will get highlighted

[Jtec75]

Thank you so much, Special-K!!! That worked perfectly for me and just what I needed. I very much appreciate your help.

20 columns, so I assume columns A:T, adjust the formula if to reflect your data.
Select the entire table
Use Conditional Formatting
Use a formula to determine...

=COUNTIF($A1:$T1,A1)>1

[Jtec75]

Hmm, I wonder, are you selecting the columns you want to apply the formula to by the header bar (where the letters are?) It worked for me by selecting the 1st cell in the field (e.g. my data starts at cell F2) and then dragging it across to cell Y2 (where it ends), and then all the way down to the bottom of the data. You have to change the letters in the formula to reflect this change (e.g. =COUNTIF($A1:$T1,A1)>1 becomes =COUNTIF($F2:$Y2,F2)>1.
Hope this works for you as this has really helped me :-)

[CRIMEDOG]

Nope - just saw that I had used greater than 0 ! Thus highlighting every number (but did not catch it because the way I set up my trial)
I had used =And(A1<>"",Countif($A1:$K1,A1)>0) this accounts for blanks. But I had used only 1 & 2 numerals for the test so all of them were duplicates in the range - changing to >1 fixed it
Once again Special K is right.

[Jtec75]

Now that this works, I would love to record a macro that does this. Every time I record it, the macro seems to ignore any of the conditional formatting I recorded. E.g, after finishing the recording, the macro only shows this:

Sub Macro6()
'
' Macro6 Macro
'

'
Range("F2:Y2").Select
Range(Selection, Selection.End(xlDown)).Select
Range("F2").Select
End Sub

[Special-K]

Time for someone else to get this one right, as VBA is not my forte.
"Once again..."

[waelbaha]

you can use Conditional Formatting tool from Styles under Home Tab
first choose the row you need to add a condition for it
make a new Rule
choose Format only unique or duplicate values
press Format
choose Fill tab
choose any color
press OK