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

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

Alternate Conditional Pattern as #'s Chg
 

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

Thanks ... Kha

"Gary''s Student" wrote:

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

Alternate Conditional Pattern as #'s Chg
 

See this:

http://tinyurl.com/5g35f3

--
Biff
Microsoft Excel MVP


"Ken" wrote in message
...
Format = aplha-numeric & they are not created by Formula ...

Thanks ... Kha

"Gary''s Student" wrote:

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

Alternate Conditional Pattern as #'s Chg
 

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" wrote:

See this:

http://tinyurl.com/5g35f3

--
Biff
Microsoft Excel MVP


"Ken" wrote in message
...
Format = aplha-numeric & they are not created by Formula ...

Thanks ... Kha

"Gary''s Student" wrote:

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

Alternate Conditional Pattern as #'s Chg
 

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

Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Ken" wrote in message
...
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" wrote:

See this:

http://tinyurl.com/5g35f3

--
Biff
Microsoft Excel MVP


"Ken" wrote in message
...
Format = aplha-numeric & they are not created by Formula ...

Thanks ... Kha

"Gary''s Student" wrote:

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