Unique IDs to change conditional format

[MFish]

Hi,

I'd like to setup a conditional format that will change accordingly to certain Unique ID's.

[TABLE="width: 500"]
<tbody>[TR]
[TD]OAK 1
[/TD]
[/TR]
[TR]
[TD]OAK 1
[/TD]
[/TR]
[TR]
[TD]OAK 2
[/TD]
[/TR]
[TR]
[TD]OAK 3
[/TD]
[/TR]
[TR]
[TD]OAK 3
[/TD]
[/TR]
[TR]
[TD]OAK 4
[/TD]
[/TR]
[TR]
[TD]OAK 5
[/TD]
[/TR]
[TR]
[TD]OAK 5
[/TD]
[/TR]
</tbody>[/TABLE]

The conditional format I'd like to run will highlight the cell range A1:D1 when the unique ID is found. In this case, the Unique ID is represented in column A:A. I'd like to know if there is a way to highlight every other unique ID with a different color, and/or, White to Grey to White to Grey. I'll be adding to this list and it auto-sorts on entry so the Unique ID will mend to the next one in line and will share the same color as it was beforehand, above.

All OAK 1 would be Grey
All OAK 2 would be White
All OAK 3 would be Grey
so on and so forth...

 

[DanteAmor]

Select columns A to D

Formula:
=MOD(VALUE(TRIM(RIGHT($A2,2))),2)

Format: Grey color