Column A

35155976

35156348

35156348

35160550

35160550

35160550

35160550

35161189

35161189

35161201

35161201

I would like to highlight the rows (Entire row) for similar values in Column A. so since A2=A3 then i would like both rows (the entire row and not only the cell) the same apply for 35160550 (A4,A5,A6 and A7)... and so on!

I've tried using the following formula: =A2=A1 and picked a color but the porblem is this formula leave the first cell of the matching series unfilled, example:

35160550

35160550

35160550

35160550

the very first "35160550" is not colored but the rest are and i need them all to be colored, plus am not able to get my conditinal formating to color the enire row.

Please help!

Thank you