How to format rows when its formatting depends on the value of other cell

**Tutai** · 09-12-2014, 11:34 AM

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

**protonLeah** · 09-13-2014, 06:15 PM

To attach a Workbook
(please do not post pictures or links to worksheets)

Click Advanced (next to quick post),
Scroll down until you see "Manage Attachments",
Click that then select "add files" (top right corner).
Click "Select Files" find your file, click "open" click "upload"
Once the upload is completed the file name will appear below the input boxes in this window.
Click "Done" at bottom right to close the Attachment Manager.
Click "Submit Reply"