Conditional Format every other

[Ken]

I have a Column consisting of random occurances of random
part numbers (PNs are sorted Ascending) ...

Above said ... Is it possible to set Conditional Format to
high-lite every other part number? ... Thanks ... Kha

 

[Kevin Stecyk]

Hi Ken,

Please see Chip Pearson's site.

http://www.cpearson.com/excel/banding.htm

I believe the link above will address your question.

Regards,
Kevin

 

[Biff]

Hi Ken,

Select the range of cells that you want to highlight.
Conditional Format
Formula Is
=MOD(ROW(),2)=1
Set the format you want
OK out

You can change which row starts the highlight by changing
the formula from =1 to =0.

Biff