How to vary shading of groups of rows, based on change in value in a particular column

I am attempting to vary shading of groups of rows, based on change in value in a particular column. For example. Column A Column B Bob 5 Bob 6 Jeff 3 Jeff 8 Jeff 2 Eric 3 Eric 7 Etc... In the above data, i need the Bob rows to be highlighted Gray, the Jeff rows to be highlighted white (or some other different color than gray, and then the Eric rows to be highlighted gray, etc. (The data is sorted by the column of interest (i.e., column A)). I would imagine this can be done with a formula using conditional formatting. Any suggestions would be appreciated.

Select all the data - I wll assume the first "Bob" is in A1 In the Conditional Formatting dialog use formulas such as =$A1="Bob" and then set the required color A formula in conditional formatting must evaluate to TRUE or FALSE best wishes -- Bernard Liengme Microsoft Excel MVP people.stfx.ca/bliengme email address: remove uppercase characters REMEMBER: Microsoft is closing the newsgroups; We will all meet again at http://answers.microsoft.com/en-us/office/default.aspx#tab=4 "Dave K" <fred.sheriff@gmail.com> wrote in message news:5dc0c9be-2f8f-4446-8336-26fb8665850d@e28g2000vbd.googlegroups.com... > I am attempting to vary shading of groups of rows, based on change in > value in a particular column. > > > > For example. > > Column A Column B > Bob 5 > Bob 6 > Jeff 3 > Jeff 8 > Jeff 2 > Eric 3 > Eric 7 > Etc... > > In the above data, i need the Bob rows to be highlighted Gray, the > Jeff rows to be highlighted white (or some other different color than > gray, and then the Eric rows to be highlighted gray, etc. > > (The data is sorted by the column of interest (i.e., column A)). > > I would imagine this can be done with a formula using conditional > formatting. Any suggestions would be appreciated. >

There are commercial alternatives. -- Jim Cone Portland, Oregon USA ( http://tinyurl.com/ShadeData ) "Dave K" <fred.sheriff@gmail.com> wrote in message news:5dc0c9be-2f8f-4446-8336-26fb8665850d@e28g2000vbd.googlegroups.com... I am attempting to vary shading of groups of rows, based on change in value in a particular column. For example. Column A Column B Bob 5 Bob 6 Jeff 3 Jeff 8 Jeff 2 Eric 3 Eric 7 Etc... In the above data, i need the Bob rows to be highlighted Gray, the Jeff rows to be highlighted white (or some other different color than gray, and then the Eric rows to be highlighted gray, etc. (The data is sorted by the column of interest (i.e., column A)). I would imagine this can be done with a formula using conditional formatting. Any suggestions would be appreciated.

Just to expand on Bernard's answer, for the example given, the formula would need to be something like: =($A1="Bob")+($A1="Eric") However, if you have many different values in A, and/or you can't be sure what they might be, you would need to use a helper column. e.g: in D1: =1 in D2:Dx =IF($A2=$A1,D1,MOD(D1+1,2)) Then in Conditional Formatting, you need only use: =D1 HTH Steve D. "Bernard Liengme" <bliengme@stfx.TRUENORTH.ca> wrote in message news:eEzaQJG$KHA.4316@TK2MSFTNGP04.phx.gbl... > Select all the data - I wll assume the first "Bob" is in A1 > In the Conditional Formatting dialog use formulas such as > =$A1="Bob" and then set the required color > A formula in conditional formatting must evaluate to TRUE or FALSE > best wishes > -- > Bernard Liengme > Microsoft Excel MVP > people.stfx.ca/bliengme > email address: remove uppercase characters > > REMEMBER: Microsoft is closing the newsgroups; We will all meet again at > http://answers.microsoft.com/en-us/office/default.aspx#tab=4 > > "Dave K" <fred.sheriff@gmail.com> wrote in message > news:5dc0c9be-2f8f-4446-8336-26fb8665850d@e28g2000vbd.googlegroups.com... >> I am attempting to vary shading of groups of rows, based on change in >> value in a particular column. >> >> >> >> For example. >> >> Column A Column B >> Bob 5 >> Bob 6 >> Jeff 3 >> Jeff 8 >> Jeff 2 >> Eric 3 >> Eric 7 >> Etc... >> >> In the above data, i need the Bob rows to be highlighted Gray, the >> Jeff rows to be highlighted white (or some other different color than >> gray, and then the Eric rows to be highlighted gray, etc. >> >> (The data is sorted by the column of interest (i.e., column A)). >> >> I would imagine this can be done with a formula using conditional >> formatting. Any suggestions would be appreciated. >>

Or a macro solution. Sub Alternate_Row_Color() 'color rows with change in data in column A 'grey, none, grey, none Dim rngName As Range Dim colIdx As Integer Dim i As Long 'Following assumes column header in row 1 Set rngName = Sheets("Sheet1").Range(Cells(1, 1), _ Cells(Rows.Count, 1).End(xlUp)) colIdx = 15 'Grey 'colIdx = xlColorIndexNone With rngName 'Color the first data row grey .Cells(1, 1).entirerow.Interior.ColorIndex = colIdx 'Starting at 2nd data row For i = 2 To .Rows.Count If .Cells(i) <> .Cells(i - 1) Then If colIdx = 15 Then colIdx = xlColorIndexNone Else colIdx = 15 End If End If .Cells(i).entirerow.Interior.ColorIndex = colIdx Next i End With End Sub Gord Dibben MS Excel MVP On Wed, 26 May 2010 12:28:48 +0100, "Steve Dunn" <stunn@sky.com> wrote: >Just to expand on Bernard's answer, for the example given, the formula would >need to be something like: > >=($A1="Bob")+($A1="Eric") > >However, if you have many different values in A, and/or you can't be sure >what they might be, you would need to use a helper column. e.g: > >in D1: > >=1 > >in D2:Dx > >=IF($A2=$A1,D1,MOD(D1+1,2)) > >Then in Conditional Formatting, you need only use: > >=D1 > > >HTH >Steve D. > > >"Bernard Liengme" <bliengme@stfx.TRUENORTH.ca> wrote in message >news:eEzaQJG$KHA.4316@TK2MSFTNGP04.phx.gbl... >> Select all the data - I wll assume the first "Bob" is in A1 >> In the Conditional Formatting dialog use formulas such as >> =$A1="Bob" and then set the required color >> A formula in conditional formatting must evaluate to TRUE or FALSE >> best wishes >> -- >> Bernard Liengme >> Microsoft Excel MVP >> people.stfx.ca/bliengme >> email address: remove uppercase characters >> >> REMEMBER: Microsoft is closing the newsgroups; We will all meet again at >> http://answers.microsoft.com/en-us/office/default.aspx#tab=4 >> >> "Dave K" <fred.sheriff@gmail.com> wrote in message >> news:5dc0c9be-2f8f-4446-8336-26fb8665850d@e28g2000vbd.googlegroups.com... >>> I am attempting to vary shading of groups of rows, based on change in >>> value in a particular column. >>> >>> >>> >>> For example. >>> >>> Column A Column B >>> Bob 5 >>> Bob 6 >>> Jeff 3 >>> Jeff 8 >>> Jeff 2 >>> Eric 3 >>> Eric 7 >>> Etc... >>> >>> In the above data, i need the Bob rows to be highlighted Gray, the >>> Jeff rows to be highlighted white (or some other different color than >>> gray, and then the Eric rows to be highlighted gray, etc. >>> >>> (The data is sorted by the column of interest (i.e., column A)). >>> >>> I would imagine this can be done with a formula using conditional >>> formatting. Any suggestions would be appreciated. >>>

Thanks very much. Used the macro first, and it worked well. On May 26, 10:23=A0am, Gord Dibben <gorddibbATshawDOTca> wrote: > Or a macro solution. > > Sub Alternate_Row_Color() > 'color rows with change in data in column A > 'grey, none, grey, none > Dim rngName As Range > Dim colIdx As Integer > Dim i As Long > 'Following assumes column header in row 1 > Set rngName =3D Sheets("Sheet1").Range(Cells(1, 1), _ > =A0 =A0 Cells(Rows.Count, 1).End(xlUp)) > colIdx =3D 15 'Grey > 'colIdx =3D xlColorIndexNone > With rngName > =A0 =A0 'Color the first data row grey > =A0 =A0 .Cells(1, 1).entirerow.Interior.ColorIndex =3D colIdx > > =A0 =A0 'Starting at 2nd data row > =A0 =A0 For i =3D 2 To .Rows.Count > =A0 =A0 =A0 =A0 If .Cells(i) <> .Cells(i - 1) Then > =A0 =A0 =A0 =A0 =A0 =A0 If colIdx =3D 15 Then > =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 colIdx =3D xlColorIndexNone > =A0 =A0 =A0 =A0 =A0 =A0 Else > =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0colIdx =3D 15 > =A0 =A0 =A0 =A0 =A0 =A0 End If > =A0 =A0 =A0 =A0 End If > =A0 =A0 =A0 =A0 .Cells(i).entirerow.Interior.ColorIndex =3D colIdx > =A0 =A0 Next i > End With > > End Sub > > Gord Dibben =A0MS Excel MVP > > > > On Wed, 26 May 2010 12:28:48 +0100, "Steve Dunn" <st...@sky.com> wrote: > >Just to expand on Bernard's answer, for the example given, the formula w= ould > >need to be something like: > > >=3D($A1=3D"Bob")+($A1=3D"Eric") > > >However, if you have many different values in A, and/or you can't be sur= e > >what they might be, you would need to use a helper column. e.g: > > >in D1: > > >=3D1 > > >in D2:Dx > > >=3DIF($A2=3D$A1,D1,MOD(D1+1,2)) > > >Then in Conditional Formatting, you need only use: > > >=3DD1 > > >HTH > >Steve D. > > >"Bernard Liengme" <blien...@stfx.TRUENORTH.ca> wrote in message > >news:eEzaQJG$KHA.4316@TK2MSFTNGP04.phx.gbl... > >> Select all the data - I wll =A0assume the first "Bob" is in A1 > >> In the Conditional Formatting dialog use formulas such as > >> =3D$A1=3D"Bob" and then set the required color > >> A formula in conditional formatting must evaluate to TRUE or FALSE > >> best wishes > >> -- > >> Bernard Liengme > >> Microsoft Excel MVP > >> people.stfx.ca/bliengme > >> email address: remove uppercase characters > > >> REMEMBER: Microsoft is closing the newsgroups; We will all meet again = at > >>http://answers.microsoft.com/en-us/office/default.aspx#tab=3D4 > > >> "Dave K" <fred.sher...@gmail.com> wrote in message > >>news:5dc0c9be-2f8f-4446-8336-26fb8665850d@e28g2000vbd.googlegroups.com.= ... > >>> I am attempting to vary shading of groups of rows, based on change in > >>> value in a particular column. > > >>> For example. > > >>> Column A =A0 =A0 =A0 =A0 Column B > >>> Bob =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A05 > >>> Bob =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A06 > >>> Jeff =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 3 > >>> Jeff =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 8 > >>> Jeff =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 2 > >>> Eric =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A03 > >>> Eric =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A07 > >>> Etc... > > >>> In the above data, i need the Bob rows to be highlighted Gray, the > >>> Jeff rows to be highlighted white (or some other different color than > >>> gray, and then the Eric rows to be highlighted gray, etc. > > >>> (The data is sorted by the column of interest (i.e., column A)). > > >>> I would imagine this can be done with a formula using conditional > >>> formatting. =A0Any suggestions would be appreciated.- Hide quoted tex= t - > > - Show quoted text -

Good to hear. Thanks. On Wed, 26 May 2010 14:58:25 -0700 (PDT), Dave K <fred.sheriff@gmail.com> wrote: >Thanks very much. Used the macro first, and it worked well. > >On May 26, 10:23�am, Gord Dibben <gorddibbATshawDOTca> wrote: >> Or a macro solution. >> >> Sub Alternate_Row_Color() >> 'color rows with change in data in column A >> 'grey, none, grey, none >> Dim rngName As Range >> Dim colIdx As Integer >> Dim i As Long >> 'Following assumes column header in row 1 >> Set rngName = Sheets("Sheet1").Range(Cells(1, 1), _ >> � � Cells(Rows.Count, 1).End(xlUp)) >> colIdx = 15 'Grey >> 'colIdx = xlColorIndexNone >> With rngName >> � � 'Color the first data row grey >> � � .Cells(1, 1).entirerow.Interior.ColorIndex = colIdx >> >> � � 'Starting at 2nd data row >> � � For i = 2 To .Rows.Count >> � � � � If .Cells(i) <> .Cells(i - 1) Then >> � � � � � � If colIdx = 15 Then >> � � � � � � � � colIdx = xlColorIndexNone >> � � � � � � Else >> � � � � � � � �colIdx = 15 >> � � � � � � End If >> � � � � End If >> � � � � .Cells(i).entirerow.Interior.ColorIndex = colIdx >> � � Next i >> End With >> >> End Sub >> >> Gord Dibben �MS Excel MVP >> >> >> >> On Wed, 26 May 2010 12:28:48 +0100, "Steve Dunn" <st...@sky.com> wrote: >> >Just to expand on Bernard's answer, for the example given, the formula would >> >need to be something like: >> >> >=($A1="Bob")+($A1="Eric") >> >> >However, if you have many different values in A, and/or you can't be sure >> >what they might be, you would need to use a helper column. e.g: >> >> >in D1: >> >> >=1 >> >> >in D2:Dx >> >> >=IF($A2=$A1,D1,MOD(D1+1,2)) >> >> >Then in Conditional Formatting, you need only use: >> >> >=D1 >> >> >HTH >> >Steve D. >> >> >"Bernard Liengme" <blien...@stfx.TRUENORTH.ca> wrote in message >> >news:eEzaQJG$KHA.4316@TK2MSFTNGP04.phx.gbl... >> >> Select all the data - I wll �assume the first "Bob" is in A1 >> >> In the Conditional Formatting dialog use formulas such as >> >> =$A1="Bob" and then set the required color >> >> A formula in conditional formatting must evaluate to TRUE or FALSE >> >> best wishes >> >> -- >> >> Bernard Liengme >> >> Microsoft Excel MVP >> >> people.stfx.ca/bliengme >> >> email address: remove uppercase characters >> >> >> REMEMBER: Microsoft is closing the newsgroups; We will all meet again at >> >>http://answers.microsoft.com/en-us/office/default.aspx#tab=4 >> >> >> "Dave K" <fred.sher...@gmail.com> wrote in message >> >>news:5dc0c9be-2f8f-4446-8336-26fb8665850d@e28g2000vbd.googlegroups.com... >> >>> I am attempting to vary shading of groups of rows, based on change in >> >>> value in a particular column. >> >> >>> For example. >> >> >>> Column A � � � � Column B >> >>> Bob � � � � � � � � �5 >> >>> Bob � � � � � � � � �6 >> >>> Jeff � � � � � � � � � 3 >> >>> Jeff � � � � � � � � � 8 >> >>> Jeff � � � � � � � � � 2 >> >>> Eric � � � � � � � � �3 >> >>> Eric � � � � � � � � �7 >> >>> Etc... >> >> >>> In the above data, i need the Bob rows to be highlighted Gray, the >> >>> Jeff rows to be highlighted white (or some other different color than >> >>> gray, and then the Eric rows to be highlighted gray, etc. >> >> >>> (The data is sorted by the column of interest (i.e., column A)). >> >> >>> I would imagine this can be done with a formula using conditional >> >>> formatting. �Any suggestions would be appreciated.- Hide quoted text - >> >> - Show quoted text -

On May 27, 6:44=A0am, Gord Dibben <gorddibbATshawDOTca> wrote: > Good to hear. > > Thanks. > > On Wed, 26 May 2010 14:58:25 -0700 (PDT), Dave K <fred.sher...@gmail.com> > wrote: > > > > >Thanks very much. Used the macro first, and it worked well. > > >On May 26, 10:23=A0am, Gord Dibben <gorddibbATshawDOTca> wrote: > >> Or a macro solution. > > >> Sub Alternate_Row_Color() > >> 'color rows with change in data in column A > >> 'grey, none, grey, none > >> Dim rngName As Range > >> Dim colIdx As Integer > >> Dim i As Long > >> 'Following assumes column header in row 1 > >> Set rngName =3D Sheets("Sheet1").Range(Cells(1, 1), _ > >> =A0 =A0 Cells(Rows.Count, 1).End(xlUp)) > >> colIdx =3D 15 'Grey > >> 'colIdx =3D xlColorIndexNone > >> With rngName > >> =A0 =A0 'Color the first data row grey > >> =A0 =A0 .Cells(1, 1).entirerow.Interior.ColorIndex =3D colIdx > > >> =A0 =A0 'Starting at 2nd data row > >> =A0 =A0 For i =3D 2 To .Rows.Count > >> =A0 =A0 =A0 =A0 If .Cells(i) <> .Cells(i - 1) Then > >> =A0 =A0 =A0 =A0 =A0 =A0 If colIdx =3D 15 Then > >> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 colIdx =3D xlColorIndexNone > >> =A0 =A0 =A0 =A0 =A0 =A0 Else > >> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0colIdx =3D 15 > >> =A0 =A0 =A0 =A0 =A0 =A0 End If > >> =A0 =A0 =A0 =A0 End If > >> =A0 =A0 =A0 =A0 .Cells(i).entirerow.Interior.ColorIndex =3D colIdx > >> =A0 =A0 Next i > >> End With > > >> End Sub > > >> Gord Dibben =A0MS Excel MVP > > >> On Wed, 26 May 2010 12:28:48 +0100, "Steve Dunn" <st...@sky.com> wrote= : > >> >Just to expand on Bernard's answer, for the example given, the formul= a would > >> >need to be something like: > > >> >=3D($A1=3D"Bob")+($A1=3D"Eric") > > >> >However, if you have many different values in A, and/or you can't be = sure > >> >what they might be, you would need to use a helper column. e.g: > > >> >in D1: > > >> >=3D1 > > >> >in D2:Dx > > >> >=3DIF($A2=3D$A1,D1,MOD(D1+1,2)) > > >> >Then in Conditional Formatting, you need only use: > > >> >=3DD1 > > >> >HTH > >> >Steve D. > > >> >"Bernard Liengme" <blien...@stfx.TRUENORTH.ca> wrote in message > >> >news:eEzaQJG$KHA.4316@TK2MSFTNGP04.phx.gbl... > >> >> Select all the data - I wll =A0assume the first "Bob" is in A1 > >> >> In the Conditional Formatting dialog use formulas such as > >> >> =3D$A1=3D"Bob" and then set the required color > >> >> A formula in conditional formatting must evaluate to TRUE or FALSE > >> >> best wishes > >> >> -- > >> >> Bernard Liengme > >> >> Microsoft Excel MVP > >> >> people.stfx.ca/bliengme > >> >> email address: remove uppercase characters > > >> >> REMEMBER: Microsoft is closing the newsgroups; We will all meet aga= in at > >> >>http://answers.microsoft.com/en-us/office/default.aspx#tab=3D4 > > >> >> "Dave K" <fred.sher...@gmail.com> wrote in message > >> >>news:5dc0c9be-2f8f-4446-8336-26fb8665850d@e28g2000vbd.googlegroups.c= om... > >> >>> I am attempting to vary shading of groups of rows, based on change= in > >> >>> value in a particular column. > > >> >>> For example. > > >> >>> Column A =A0 =A0 =A0 =A0 Column B > >> >>> Bob =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A05 > >> >>> Bob =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A06 > >> >>> Jeff =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 3 > >> >>> Jeff =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 8 > >> >>> Jeff =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 2 > >> >>> Eric =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A03 > >> >>> Eric =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A07 > >> >>> Etc... > > >> >>> In the above data, i need the Bob rows to be highlighted Gray, the > >> >>> Jeff rows to be highlighted white (or some other different color t= han > >> >>> gray, and then the Eric rows to be highlighted gray, etc. > > >> >>> (The data is sorted by the column of interest (i.e., column A)). > > >> >>> I would imagine this can be done with a formula using conditional > >> >>> formatting. =A0Any suggestions would be appreciated.- Hide quoted = text - > > >> - Show quoted text -- Hide quoted text - > > - Show quoted text - Gord, you are an expert in writing macro, would you please advise a site for learning this? Thanks in advance. Pat

Far from expert. Learn much from watching these news groups, specifically the programming group. Here are some sites that you can browse through. http://www.codesites.com/ http://www.contextures.com/ see Debra's book list http://www.cpearson.com/excel.htm http://www.j-walk.com/ss/excel/links/ http://www.mvps.org/dmcritchie/excel/excel.htm http://edc.bizhosting.com/english/index.htm http://www.oaltd.co.uk/Excel/Default.htm http://www.vbapro.com/ Gord On Thu, 27 May 2010 17:51:36 -0700 (PDT), PatLee <patlee311@gmail.com> wrote: >Gord, >you are an expert in writing macro, would you please advise a site for >learning this? > >Thanks in advance. >Pat

On May 28, 9:23=A0am, Gord Dibben <gorddibbATshawDOTca> wrote: > Far from expert. > > Learn much from watching these news groups, specifically the programming > group. > > Here are some sites that you can browse through. > > http://www.codesites.com/http://www.contextures.com/=A0 see Debra's book = listhttp://www.cpearson.com/excel.htmhttp://www.j-walk.com/ss/excel/links/h= ttp://www.mvps.org/dmcritchie/excel/excel.htmhttp://edc.bizhosting.com/engl= ish/index.htmhttp://www.oaltd.co.uk/Excel/Default.htmhttp://www.vbapro.com/ > > Gord > > On Thu, 27 May 2010 17:51:36 -0700 (PDT), PatLee <patlee...@gmail.com> > wrote: > > > > >Gord, > >you are an expert in writing macro, would you please advise a site for > >learning this? > > >Thanks in advance. > >Pat- Hide quoted text - > > - Show quoted text - Gord, many thanks. Pat

Similiar Articles:

How to vary shading of groups of rows, based on change in value in ...
I am attempting to vary shading of groups of rows, based on change in value in a particular column. For example. Column A Column B ...

Changing columns to rows - microsoft.public.mac.office.excel ...
How to vary shading of groups of rows, based on change in value in ... I am attempting to vary shading of groups of rows, based on change in value in a particular column.

Autofill Based on a Changing Column - microsoft.public.excel ...
How to vary shading of groups of rows, based on change in value in ... Autofill Based on a Changing Column - microsoft.public.excel ... How to vary shading of groups of ...

how to sort the rows based on data in one column - microsoft ...
... ways to skin this particular cat ... how to sort the rows based on data in one column - microsoft ... How to vary shading of groups of rows, based on change in value in ...

Formatting or Grouping multiple rows based on unique values ...
How to vary shading of groups of rows, based on change in value in ... Formatting or Grouping ... Color Row based on value in a Column (#row) Select ... Multiple ...

How to reverse column values in excel? - microsoft.public.excel ...
How to vary shading of groups of rows, based on change in value in ... How to reverse column values in excel? - microsoft.public.excel ... How to vary shading of groups of ...

Set multiple fills in single column based on value - microsoft ...
How to vary shading of groups of rows, based on change in value in ... Set multiple fills in single column based on value - microsoft ... How to vary shading of groups of ...

In excel change color of a range of cells based on a cell value ...
How to vary shading of groups of rows, based on change in value in ... In ... based on a cell value ..... you can ... in i have to change the List report column color based ...

Conditional formatting based on Column header - microsoft.public ...
How to vary shading of groups of rows, based on change in value in ... Conditional formatting based on Column header - microsoft.public ... How to vary shading of groups ...

Map one more column map within a single XSD element. - microsoft ...
How to vary shading of groups of rows, based on change in value in ... Map one more column map within a single XSD element. - microsoft ... How to vary shading of groups ...

Excel - Colour Rows Based On Changing Values - Hello I have ...
... group rows based on the value in Column ... change the colour of the cells in column range I3:I216 based ... particular row to shade grey (or any colour) if the status (column ...

Conditional Formatting in Excel - color coding rows based on ...
... rows based on groups of ... shading of rows based on data in a particular column. For example, cell B1:B5 have the same value, so ... on column B data but the values will change ...

7/20/2012 12:42:35 PM