Highlight Data

[Guest]

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

 

[Guest]

You need to be more specific when you say similar. You could use conditional
formatting,say for example if you wanted to highlight all the ones that were
8 characters in length
..
Highlight the data (E1:E9)
Click Format>Conditional Formatting
Condition 1 = Is Formula
In the formula box type in =len(E1)=8
Then put in a format and click OK.

Post back if nessecassry if you need to clarify similiar.

 

[Jim Cone]

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
(e-mail address removed)