Macro To Colour In Rows

[Dazzawm]

I have upto 10000 rows with data in. I need the macro to look at the data in column 'C' and whenever the data changes I need it to change colour and colour in the whole row.

i.e C1:C10 has the same data and the macro colours in the rows red, C11:C20 the data is different so the rows get coloured yellow and so on. I know if there are 10000 rows it would be a lot of colours, but after say using 10 colours in can start again.

Thanks.

 

[RSXchin]

You got it!

you'd also need to change this line.

For i = 1 To Cells(Rows.Count, 3).End(xlUp).Row

The 3 is for C. You could also just change all the 3's to "C". be sure to put it in quotes!!!!

 

[Dazzawm]

Thanks for all your help