DJ,

My "Shade Data Rows" Excel add-in will do that.
It pops up a form and you choose the compare column.
Option to shade the selection or across the entire sheet.
Also, does every nth row. Three colors available (dark or light).
Available free upon direct request. Remove xxx from email address.

Jim Cone
San Francisco, USA
XX

"DJ" wrote in message ...
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