Could not change the cell color using VBA

[kvramana82]

Hi All,

In attached file, i could not change the color of row 74,75 and 76 as excel changing the m value to 47 when it reached to 74 as values are not unique.

Can anyone suggest me to change the color of the above mentioned rows.

Thanks,

Ramana.