Please help! formatting last row

Can someone please help me with the next peice of code required for this:

I want to go to the last row of the sheet and add some BOLD and Colour formatting.

the TOTALS range is C26:X26 (although the amount of rows change on a daily basis)

I have all the code working, and have got as far as:

 With Sheets("Sheet1")
             .Range("C" & .Rows.Count).End(xlUp).Select
              ActiveCell.Offset(0, -1) = "Turnover"
    
           End With

Which adds "Turnover" into cell B**, I then want to format the subtotals to BOLD and highlight the cells as GREY.


Can anyone help please?


thankyou.