- 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
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
