my excel is like this

Australia xxx 100
yyy 200
zzz 300
Australia total 600

UK xxx 400
yyy 200
zzz 600
UK total 1200


i want to set a macro so that if the cell in column A contains "total", the
row colour (in this case, Australia total & UK total) will change into yellow
automatically..

thanks in advance for help