Charlie987
New Member
- Joined
- Jul 25, 2020
- Messages
- 25
- Office Version
- 365
- Platform
- Windows
Hi,
I am hoping to be able to iterate over a list of names where the first and last names are in different cells and format the colour of each persons set of rows eg.
Peter | Smith| 1
Peter | Smith | 2
Sam | Wright | 1
Sam | Wright | 2
Sam | Wright | 3
John | White | 1
In this example it would format the two rows for peter smith in one colour eg. Light blue
and then the three rows for Sam Wright would all be a different colour eg. white
and then the row for John White would be back to light blue again
The range will be dynamic because is it generated from another workbook.
I can quite figure out how to get it working with the names being in different columns
If any one had any thoughts it would be greatly appreciated.
Thanks!
I am hoping to be able to iterate over a list of names where the first and last names are in different cells and format the colour of each persons set of rows eg.
Peter | Smith| 1
Peter | Smith | 2
Sam | Wright | 1
Sam | Wright | 2
Sam | Wright | 3
John | White | 1
In this example it would format the two rows for peter smith in one colour eg. Light blue
and then the three rows for Sam Wright would all be a different colour eg. white
and then the row for John White would be back to light blue again
The range will be dynamic because is it generated from another workbook.
I can quite figure out how to get it working with the names being in different columns
If any one had any thoughts it would be greatly appreciated.
Thanks!