View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ken Ken is offline
external usenet poster
 
Posts: 590
Default Alternate Conditional Pattern as #'s Chg

Excel2003 ...

I have a list of numbers which may repeat a random # of times.
The numbers are sorted in Ascending order.

Each time the number chgs I wish Conditional Format to "Alternate" the Cell
Pattern (ie: Blue, Grn, Blue, Grn etc)

What would Conditional Format formula be to achieve this?

Thanks ... Kha