Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change background color using conditional formatting | Excel Worksheet Functions | |||
Conditional Formatting for alternate client refs | Excel Worksheet Functions | |||
Conditional Formating Background Color | Excel Discussion (Misc queries) | |||
Alternate Background-colors | Excel Discussion (Misc queries) | |||
Conditional formatting: alternate shading PLUS red for 0 values | Excel Discussion (Misc queries) |