Conditional formatting: same color, alternate background on same r
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. |
Conditional formatting: same color, alternate background on same r
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. |
All times are GMT +1. The time now is 05:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com