Ken,

If I'm correct, you want to have a one format for odd part numbers and one
for even part numbers. I don't think that's possible within the software.

One possible solution to your problem could be to add a column next to your
parts list. Within the column use this function
=IF(A1/2TRUNC(A1/2,0),"ODD","EVEN"). Then you can use the conditional
format for that column to differentiate between odd and even part numbers. A
test of the function with A1 = 3, 3/2 = 1.5, TRUNC(1.5)=1. 1.51 = TRUE, ODD
will show up. Say A1 = 4, 4/2 = 2, TRUNC(2) = 2 22 = FALSE, EVEN.

Not sure if that's what you're looking for, but hope it helped.

"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