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.