View Single Post
  #4   Report Post  
Jim May
 
Posts: n/a
Default

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