I have a series of data & I'd like the background to change color when the
color above is the same but I alse want that same color to be applied to the
current cell. For example
Value Background
1 blue
1 blue
1 blue
2 purple
2 purple
3 none
4 blue
5 blue
6 none
7 none
8 purple
8 purple
9 blue
9 blue
9 blue
9 blue
10 none

I tried this formula: =OR($B757=$B756,$B757=$B758)

but I'm only able to define one color. I need to be able to pick different
colors to differentiate the groupings.

Thanks for your help.

Try David McRitchie's page at:
http://www.mvps.org/dmcritchie/excel/condfmt.htm
Scroll down a bit (about 1/3 down) to the section:
Color Grouping with alternating colors (#grouping)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Tim Toennies" wrote:
> I have a series of data & I'd like the background to change color when the
> color above is the same but I alse want that same color to be applied to the
> current cell. For example
> Value Background
> 1 blue
> 1 blue
> 1 blue
> 2 purple
> 2 purple
> 3 none
> 4 blue
> 5 blue
> 6 none
> 7 none
> 8 purple
> 8 purple
> 9 blue
> 9 blue
> 9 blue
> 9 blue
> 10 none
>
> I tried this formula: =OR($B757=$B756,$B757=$B758)
>
> but I'm only able to define one color. I need to be able to pick different
> colors to differentiate the groupings.
>
> Thanks for your help.