Sunday, December 2, 2018

microsoft excel - How to highlight multiple rows based on column cell numbers?

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

hard drive - Leaving bad sectors in unformatted partition?

Laptop was acting really weird, and copy and seek times were really slow, so I decided to scan the hard drive surface. I have a couple hundr...