VBA highlight subtotal and grand total on multiple sheets

[galmond1010]

I would like to highlight column C with the text "Total" and "Grand Total" on multiple sheets using VBA. Can anyone assist? I have the VBA for a single sheet but can't seem to figure out how to go to the next sheet without debugging. Thank you in advance.

 

[DanteAmor]

I'm glad to help you. I appreciate your kind comments.