Macro for Varying Number of Rows

G

Gianella Azzopardi

Joined
Oct 29, 2015
Messages
2
Reaction score
0
Hi,

I have an excel file which has a number of entries. Each entry however has a varying number of rows within in - you can see the example attached for a better idea of what I'm talking about. I would like to have another column so that when I enter 'YES' within that cell, the whole entry is turned grey. My problem is that each entry has a varying number of columns within it. Is there a way I can do this using a macro?

Thanks

Gianella
 

Attachments

  • Extract.JPG
    Extract.JPG
    59.4 KB · Views: 184

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying a formula to a range 2
Macro to Delete the last N rows 9
Summary Worksheet. 1
Formatting/Totalling Macro with varying rows of data 2
Copy summary data to new sheet 1
Macro to Combine Data from Multiple Sheets with Cell References 4
Sorting and grouping data with varying number or rows 1
Code to delete rows with varying amounts of data 2

Top