Alternate Conditional Pattern as #'s Chg

[Ken]

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

 

[Gary''s Student]

Do the numbers change because the cell contains a formula or do they change
because of user input??

 

[Ken]

Format = aplha-numeric & they are not created by Formula ...

Thanks ... Kha

 

[T. Valko]

See this:

http://tinyurl.com/5g35f3

 

[Ken]

T. (Good afternoon)

You did it again ... Initially, I thought this would be an easy one ... I
tried the Formulas ... They worked fine, but scrolling practically stopped
.... Cosequently, I went with the "Helper" Col method.

Thanks again for supporting these boards & for your many solutions ... Kha

 

[T. Valko]

Yeah, those are calculation intensive formulas so would not be a good
solution on large amounts of data.

Thanks for the feedback!