Conditional formatting: same color, alternate background on same r

T

Tim Toennies

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top