I'm trying to figure out a way to create an excel formula, or vba that will
allow me to highlight rows of similar data.

For example, I have the following information:

..
..
BW404988
BW404988
M9610-3069S
M9610-3069S
M9610-3069S
BM404701
BM404701
BM404701
BM404701
..
..
so I'm wanting a formula that would highlight the first two, then not the
next three, then the next four. Does anyone know of how to do this? There
won't necessarily be this 2, 3, 4 pieces of data. I'm trying to base it off
of information found within column E.

Thanks much,
DJ