Hi all,
I'm trying to figure out how to create a macro which would look for a specified value in Column A, and highlight subsequent columns for that value in a particular color. Then, if it finds a different value in Column A, it would highlight those rows a different color, and so on.
Here's an example of what I'm referring to:
So there's just 2 columns. Column A has a numeric value, Column B has a name. So what I'm looking to do is highlight all of the four rows in which Column A = 1 a random color. Then, it would highlight the next two rows (in which Column A = 2) a different color. Then, finally, it would highlight the last five rows (Column A = 3) another color.
Column A Column B
1 Joe
1 Bob
1 Mary
1 Tom
2 Mike
2 Suzy
3 Lauren
3 Brian
3 Bill
3 Mary
3 Steve
Any help would be appreciated - thanks!
I'm trying to figure out how to create a macro which would look for a specified value in Column A, and highlight subsequent columns for that value in a particular color. Then, if it finds a different value in Column A, it would highlight those rows a different color, and so on.
Here's an example of what I'm referring to:
So there's just 2 columns. Column A has a numeric value, Column B has a name. So what I'm looking to do is highlight all of the four rows in which Column A = 1 a random color. Then, it would highlight the next two rows (in which Column A = 2) a different color. Then, finally, it would highlight the last five rows (Column A = 3) another color.
Column A Column B
1 Joe
1 Bob
1 Mary
1 Tom
2 Mike
2 Suzy
3 Lauren
3 Brian
3 Bill
3 Mary
3 Steve
Any help would be appreciated - thanks!
