vba: color fill

I am trying to color code certain rows in my data.
there are only two columns a, column b.

i am hoping my code below will look at some row number in column 1 and look for a value "total", then again, look on the same row number, column 2 and look for value "1", then color fill it.

Please Login or Register  to view this content.

but its not doing it;(

thanks again for your responses