Not sure I'm clear on what you want to do, but if I am I don't see how
"conditional" formatting is going to work. The records in alternating rows
would have to meet/not meet the condition. The way I understand the nature of
you data and the Asc sort, this isn't going to happen.

Why can't you just format all ODD ROW cells in col. A one way & format the
EVEN ROW cells another? That would give your alternating formatting
regardless of what the cell content was or how the column is sorted.

What am I missing?
"Ken" wrote:

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