alternating colors as column values change w/ CF

[news.microsoft.com]

how to alternating colors as column values change.
the article below tells me how but I don't want to use any additional
helper columns.
any ideas?

http://www.mvps.org/dmcritchie/excel/condfmt.htm (search with "Color
Grouping with alternating colors")

 

[Bernard Liengme]

I can use conditional formatting on A1:A10 such that if any number falls
below 5 the cell goes blue while any cell with value baove 12 is red. All
without helper columns.
Tell us what you would wish to do.

 

[news.microsoft.com]

col1 cf(bg color)
a -- red
a -- red(same color above because col1 doesn't
change(a(above,current row)
b -- blue(change color because col1 changes a(above) to b(current row)
b -- blue(same color above because col1 doesn't
change(b(above,current row)
b -- blue(same color above because col1 doesn't
change(b(above,current row)
c -- red ...
c -- red ...
a -- blue ...
a -- blue ...

clear?

Bernard Liengme 쓴 글:

 

[Bernard Liengme]

Experiment with:
Formula Is =AND(A2=A1,A2=A3) format Blue
best wishes

 

[news.microsoft.com]

doesn't work at all.

Bernard Liengme ¾´ ±Û:

Experiment with:
Formula Is =AND(A2=A1,A2=A3) format Blue
best wishes