Conditional Format every other

  • Thread starter Thread starter Ken
  • Start date Start date
K

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
 
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
 
Back
Top