abenitez77
Board Regular
- Joined
- Dec 30, 2004
- Messages
- 149
I have a button that when clicked, it starts formatting an excel file which I select. I have data in columns A thru L. The rows will vary for each file I get, which I get biweekly. In row A, I have a column called colors and the cell contains a string with the name of a color (ie see below). I want to insert a row between each color that changes and fill the cells with grey in columns B thru H. How can I do this?
Red
Red
Red
Green
Green
Green
Blue
Orange
Orange
Yellow
White
Red
Red
Red
Green
Green
Green
Blue
Orange
Orange
Yellow
White