Formating

Hello Jo
Thank you for your question

You could use the conditional formatting tool. I have attached an example workbook to make it clearer. You will need to have to word total or subtotal in the first column on correct row. Then highligh both columns and go to Format, Conditional Formatting and in the drop down list choose 'Formula is.' In the box next to it write the following formula:

=RIGHT($A1,5)="Total"

Click OK and this should bold any total rows automatically.

If this resolves your question, please mark it as resolved. If not, please reply with more information.

Kind regards
Cress