I'd like to automatically highlight multiple rows based on the group of numbers in one column. So I would have a different row color for each unique family ID. Is there a way to do this without manually having to select a color in conditional formating? I have 400 families and 1000+ rows. Thanks for the help guys.
Example data:
FamilyID Stock Number Class
1922 1361427 Box
1922 5859184 Box
1922 1422784 Box
1922 1422694 Box
2196 1336358 Circle
2196 1336244 Circle
2196 675239 Circle
2205 57813 Square
2205 863453 Square
2220 30664 Square
2220 1336732 Square
2220 22874 Square
No comments:
Post a Comment