highlight cel with repeated number

[whitoulias]

Hello to all

I have the following table going down to 3000 rows

[TABLE="width: 200"]
<TBODY>[TR]
[TD]01/01/2013</SPAN>[/TD]
[TD]6</SPAN>[/TD]
[TD]17</SPAN>[/TD]
[TD]21</SPAN>[/TD]
[TD]26</SPAN>[/TD]
[TD]35</SPAN>[/TD]
[/TR]
[TR]
[TD]01/01/2013</SPAN>[/TD]
[TD]1</SPAN>[/TD]
[TD]2</SPAN>[/TD]
[TD]15</SPAN>[/TD]
[TD]17</SPAN>[/TD]
[TD]20</SPAN>[/TD]
[/TR]
[TR]
[TD]02/01/2013</SPAN>[/TD]
[TD]7</SPAN>[/TD]
[TD]10</SPAN>[/TD]
[TD]15</SPAN>[/TD]
[TD]25</SPAN>[/TD]
[TD]31</SPAN>[/TD]
[/TR]
</TBODY><COLGROUP><COL><COL span=5></COLGROUP>[/TABLE]


What i would like is a code checking whether a number/ or numbers is repated and then highlight it with any color.
For example the code will check the 2nd row for numbers repeating from the 1st row. Then it will check the 3rd row for numbers repeating from the 2nd line and so on.

Any ideas?

Thank you all

 

[c_m_s_jr]

Assuming your data starts in row 1 and using 2007 or later

1) Highlight your data starting in B2:F3000
2) Select Home Tab
3) Select Conditional Formating
4) New Rule
5) Use a formula
6) =SUM(IF(B2=$B1:$F1,1,0))
7) Select to fill the cell with a color

 

[whitoulias]

Sorry for not mentioned it

2003 excel

 

[Rick Rothstein]

Sorry for not mentioned it

2003 excel

Adjusting c_m_s_jr's steps from Message #2 for XL2003...

Assuming your data starts in row 1 and using 2007 or later

1) Highlight your data starting in B2:F3000
2) Click Format/Conditional Formating on the menu bar
3) Select "Formula Is" from the first drop down
4) Put this formula in the empty field to the right... =SUM(IF(B2=$B1:$F1,1,0))
5) Click the Format button
6) Select to fill the cell with a color
7) Click OK twice to return to the worksheet

 

[whitoulias]

most thankful to both of you