Ken,

The following is for where the p/n is in column A, starting in A2, down.
PUt the following in column B (helper column) (you can hide it), starting in
B2. Copy down.

=IF(A2=A1,B1,MOD(B1+1,2))

B1 should be empty, or 0 or 1.

Select your rows, or parts thereof. FOrmat - Conditional format - Formula
is. This is for where the active (white) cell of your selection is in row
2. Change the 2 in the formula to match:

=$B2=1

Select your format color.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Ken" wrote in message
...
Excel 2000 ... Ok ... time to clarify ...

ColA ... I have random apha-numeric part numbers that
often repeat ... So when sorted (Ascending) I may have 1
occs of 1 pn ... & 5 occs of another pn etc ... Also I
may have multiple "odd" or "even" pns in a row.

Part # ... High-Light
Format color
123456 ... Red
123456 ... Red
123456 ... Red
234567 ... Green
234567 ... Green
345678 ... Red
345680 ... Green
345680 ... Green
etc

I wish to set Conditional formatting to high-lite every
other "like" pn ... Thanks Kha ...


-----Original Message-----
Click on first Row-header desired, then Conditional
Formatting
Formula is: and in box enter =MOD(ROW(),2)=1; enter
pattern desired, OK
out.
Click again on same Row-header, then click the Format-
Painter Icon
left-click the Row-header immediately below and drag-
down (staying inside
the row-header column) as far as you'd like to have the
formatting go.
HTH


"Ken" wrote in
message
...
Excel 2000 ... What I have

Col A ... consist of random alpha-numeric part numbers
that when sorted (Ascending) ... may have
multiple "odds"
or multiple "evens" in a row.

Above said ... I would like to set Conditional
Formatting
to high-lite every other part number.

What might that Conditional Formula be?

Thanks ... Kha


.