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
|