Clearing Blank rows of background colour

[Jokky]

Good morning everyone. My name is Joaquin and i am in South Africa. This is my first ever post so forgive me if i am at the wronge place. I am trying to find a macro that will find all blanck rows in my data from A3: R250 and strip the cell of the colour.
i have a macro that inserts blank rows inbetween the data change. but when a data row is coloured, it inserts the row and colours the blank row with what ever colour the row above is.I want to clear the colours from the inserted blank rows. Can any one wite me a macro that will do that please?

 

[Michael M]

Try using

Sub MM1()
Dim lr As Long, r As Long
lr = Cells(Rows.Count, "A").End(xlUp).Row
For r = lr To 1 Step -1
    If Range("A" & r).Value = "" Then Rows(r).Interior.Pattern = xlNone
Next r
End Sub

 

[Jokky]

Thank you very very very much. I tried every thing i know and nothing worked

 

[Michael M]

Do you get an error ?
Where are you putting the code ?
Are the cells truly blank ?