Excel color similar rows with different colors
Posted on 2014-04-01
I have an excel sheet with following pattern:
A B C D E
1 Title Title Title Title Title
2 AAA zxc ad ed dfg
3 AAA ewr fgh vbn qwe
5 BBB sdf cvb ttw uyi
I would like to color the rows which have same values and differentiate between the values colors, 2 colors are enough.
All AAA - rows will be colored light green
All BBB - rows will be colored light blue
All CCC - rows will be colored light green again, etc`.