Hi excelforum Experts,

I am trying to format the entire row into Bold if the cell contains the word "Total". Is it correct putting an asterisk sign as prefix and suffix to the word "Total" as wild character to capture each cell that contains the word "Total"?

Here are the possible words that will contain the word Total:
1.) Total Assets
2.) Total Liabilities
3.) Total Equities
4.) Grand Total
5.) Sub-total
6.) And so on...

Please see VBA code below that I am referring to:

VBA Code Sample.png

I appreciate if there could be someone that could help me fix the VBA code above and arrived at my desired output as mentioned above. Thanks!

Warmest regard,
Arnel