View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Alternate Conditional Pattern as #'s Chg

Do the numbers change because the cell contains a formula or do they change
because of user input??
--
Gary''s Student


"Ken" wrote:

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