| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting: same color, alternate background on same r | Excel Worksheet Functions | |||
| conditional format if cell value 0 pattern red value blank nothing | Excel Worksheet Functions | |||
| Conditional Formatting for alternate client refs | Excel Worksheet Functions | |||
| Recognition of color pattern in cells to use in Conditional format | Excel Discussion (Misc queries) | |||
| Conditional formatting: alternate shading PLUS red for 0 values | Excel Discussion (Misc queries) | |||
Hybrid Mode
