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
.
|