Macro to look for common value in Column A, and highlight those rows particular color

[bjcf33183]

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!

 

[6StringJazzer]

Do you know in advance what the numbers are going to be? Or are you saying:

• Use one color starting in row 1 until the number in column A changes
• Use another color starting in that row until the number in column A changes again
• Use another color starting in that row until the number in column A changes again

Do you know in advance how many different numbers there will be?

Do you have to use a different color for each new number, or can you alternate back and forth between two colors?

This can be done with conditional formatting but you need a different rule for each color. It could also be done with VBA.

I just want to make sure it's clear what the logic is for the numbers. You started out by saying " a specified value in Column A" but you never specified a value for column A. It looks like whatever the value is in the first row is the one you want to make the first color.

 

[bjcf33183]

Do you know in advance what the numbers are going to be?

No - this would be variable

Do you know in advance how many different numbers there will be?

Nope - this is also variable.

Do you have to use a different color for each new number, or can you alternate back and forth between two colors

Alternating back and forth between 2 colors would work as well.

Thanks!

 

[Fluff]

Assuming your data start in row, select A1 to the last row, in conditional formatting use this formula
=MOD(SUM(--(FREQUENCY($A$1:$A1,$A$1:$A1)>0)),2)<>0
select a format
Then create another rule with
=MOD(SUM(--(FREQUENCY($A$1:$A1,$A$1:$A1)>0)),2)=0