Conditional Formating in subtotal rows

[Amarino]

I am working on a sheet that subtotals final amount by individual location. I have the code and created the subtotals; however, I need to create a macro that formats the entire row (i.e A10:Y10). I can not have it as a defined row since the row may change day to day. I just need to format the subtotal rows to a background color of yellow and the fonts bold. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
I am basically looking for a code that state the following:<o></o>
"If Col A contains "Total" turn that cell yellow and each cell in that row yellow until column Y)<o></o>

 

[GlennUK]

Have you considered using Conditional Formatting for this?

 

[Amarino]

Thats what i am looking to do; however, I can not figure out how to set up a conditional format for the entire row or set range. I haven't created macros in over 10 years so i am trying to re-learn. I do not know any conditional formating code. Any suggestions would help.