Macro to Seach word and color the row till G coloum.

[shiva_reshs]

Hello Friends,

I am working in this file, which has a multiple table in single sheet. Each table has a grand total at the bottom. I am trying to add macro in excel which search the Grand Total in sheet and add color in that entire row upto column H. Is this be possible?

I found this

Please Login or Register  to view this content.

This does the entire row. But I need coloring till Coloumn H only.

Thanks.

[barryleajo]

Yes it is possible but please post an example worksheet to show us the layout of your data.

[shiva_reshs]

Hey,

Thanks for you reply. I am at office right now, so wont be able to upload any document. I have to go to home to do it from my home PC.

If is just a simple sheet with Row 10, row 20, row 30 and row 40 has "Grand Total" in the Coloum A. I need it to have color till Coloum H in front of each Grand total rows.

If you need a file, i can upload it from my home but later in the evening.

Thanks for your quick reply.

Regards

[barryleajo]

shiva_reshs
One way, assuming the "Grand Total" text is in col A

Please Login or Register  to view this content.

[shiva_reshs]

Thanks Barry, It works like a charm. However, can I tweak the color into below color.

Please Login or Register  to view this content.

Thanks for your help.
Regards
Shiva

[barryleajo]

shiva_reshs
Yes, essentially, just replace my 'colour' line with your coding

Please Login or Register  to view this content.

If this meets your requirement please mark your thread as SOLVED
barry

[shiva_reshs]

Thanks, It worked.

Regards,