Hi,
I am new to this vba excel macro and coding. Need help to automate formating my excel. Below are my queries

1. Need to Bold the entire row with value "Grand Total" and "SL Defect Total"
2. Need to merge cells but the range varies . Consider the below example . How to merge the cells for value containing "status" as the columns under neath it may vary. some times only two columns sometimes 4 columns. In this case how to select the range and format the cells.

Status
Pass Failed Deferred Ready