How to copy table cell shading to another cell in Word?

Discussion in 'Word Tables' started by owyheerover, Nov 27, 2008.

  1. owyheerover

    owyheerover Guest

    I have added cell shading to a table cell in word. Now I would like to
    repeat this color in another cell. But I cannot figure out what the current
    color is.

    The "Shading" tool does not display the current shading of the cell.

    When the cell was first shaded, the color was then displayed in the
    "recently used colors" list. But since closing word and reopening, this list
    is blank.

    How can I determine what the cell shading is, or copy the shading to another
    cell?

    Thanks.

    --
    Bill Clark
    www.earthpoint.us
     
    owyheerover, Nov 27, 2008
    #1
    1. Advertisements

  2. "owyheerover" wrote:

    > I have added cell shading to a table cell in word. Now I would like to
    > repeat this color in another cell. But I cannot figure out what the current
    > color is.
    >
    > The "Shading" tool does not display the current shading of the cell.
    >
    > When the cell was first shaded, the color was then displayed in the
    > "recently used colors" list. But since closing word and reopening, this list
    > is blank.
    >
    > How can I determine what the cell shading is, or copy the shading to another
    > cell?


    If you selectt he cell, and then do Format > Borders and Shading... >
    Shading tab, Word will tell you the shade being used in the current cell.
    Just make sure to select cell(s) that all have the exact same colour.

    To copy quickly from one cell to another, I believe you need a macro for
    that. Do you want to go that way or just do it manually?
     
    Jean-Guy Marcil, Nov 27, 2008
    #2
    1. Advertisements

  3. owyheerover

    owyheerover Guest

    For me, using Word 2007, the shading tab does not show the current color.
    The conditions are
    1) it is a custom color
    2) close word and reopen the file.

    You can see a picture at http://www.earthpoint.us/downloads/shading.jpg

    --
    Bill Clark
    www.earthpoint.us


    "Jean-Guy Marcil" wrote:

    > "owyheerover" wrote:
    >
    > > I have added cell shading to a table cell in word. Now I would like to
    > > repeat this color in another cell. But I cannot figure out what the current
    > > color is.
    > >
    > > The "Shading" tool does not display the current shading of the cell.
    > >
    > > When the cell was first shaded, the color was then displayed in the
    > > "recently used colors" list. But since closing word and reopening, this list
    > > is blank.
    > >
    > > How can I determine what the cell shading is, or copy the shading to another
    > > cell?

    >
    > If you selectt he cell, and then do Format > Borders and Shading... >
    > Shading tab, Word will tell you the shade being used in the current cell.
    > Just make sure to select cell(s) that all have the exact same colour.
    >
    > To copy quickly from one cell to another, I believe you need a macro for
    > that. Do you want to go that way or just do it manually?
     
    owyheerover, Nov 27, 2008
    #3
  4. The following will set the shading of the first table in a document to the
    shading that is applied to the cell in the first column of the first row of
    the second table in the document.

    With ActiveDocument
    .Tables(1).Shading.BackgroundPatternColor = .Tables(2).Cell(1,
    1).Shading.BackgroundPatternColor
    End With


    --
    Hope this helps.

    Please reply to the newsgroup unless you wish to avail yourself of my
    services on a paid consulting basis.

    Doug Robbins - Word MVP

    "owyheerover" <> wrote in message
    news:...
    >I have added cell shading to a table cell in word. Now I would like to
    > repeat this color in another cell. But I cannot figure out what the
    > current
    > color is.
    >
    > The "Shading" tool does not display the current shading of the cell.
    >
    > When the cell was first shaded, the color was then displayed in the
    > "recently used colors" list. But since closing word and reopening, this
    > list
    > is blank.
    >
    > How can I determine what the cell shading is, or copy the shading to
    > another
    > cell?
    >
    > Thanks.
    >
    > --
    > Bill Clark
    > www.earthpoint.us
     
    Doug Robbins - Word MVP, Nov 27, 2008
    #4
  5. owyheerover

    Klaus Linke Guest

    "Jean-Guy Marcil" wrote:
    > If you selectt he cell, and then do Format > Borders and Shading... >
    > Shading tab, Word will tell you the shade being used in the current cell.
    > Just make sure to select cell(s) that all have the exact same colour.


    If you've done one cell, you can select another cell and hit F4, to apply
    the same shading.

    Klaus
     
    Klaus Linke, Nov 28, 2008
    #5
  6. owyheerover

    hks Guest

    Klaus Linke;381011 Wrote:
    > "Jean-Guy Marcil" wrote:-
    > If you selectt he cell, and then do Format Borders and Shading...
    > Shading tab, Word will tell you the shade being used in the current
    > cell.
    > Just make sure to select cell(s) that all have the exact same
    > colour.-
    >
    > If you've done one cell, you can select another cell and hit F4, to
    > apply
    > the same shading.
    >
    > Klaus


    you can ctrl + c to cell padding which you want copy, or you block your
    cell padding after that copy..
    and paste to your word.




    --
    hks
     
    hks, Nov 28, 2008
    #6
  7. "owyheerover" wrote:

    > For me, using Word 2007, the shading tab does not show the current color.
    > The conditions are
    > 1) it is a custom color
    > 2) close word and reopen the file.
    >
    > You can see a picture at http://www.earthpoint.us/downloads/shading.jpg


    And if you click on "More Colours..."?
     
    Jean-Guy Marcil, Nov 28, 2008
    #7
  8. It's too bad that W2007 is even more picky about giving up the color numbers
    than W2003 is (you can't just have the cursor in the cell; the cell must be
    selected, etc.). You've probably already noticed that as long as you are in
    the same W2007 session that the color was chosen in, it will be highlighted
    in either in the theme, standard colors, or recent colors sections of the
    shading dropdown. In later sessions, go to the reveal formatting pane
    (styles pane > style inspector (does anyone see a use for this feature?)
    button > reveal formatting button—or add the reveal formatting command to
    your QAT) to get the color number.

    PamC

    owyheerover wrote:
    >For me, using Word 2007, the shading tab does not show the current color.
    >The conditions are
    >1) it is a custom color
    >2) close word and reopen the file.
    >
    >You can see a picture at http://www.earthpoint.us/downloads/shading.jpg
    >
    >> > I have added cell shading to a table cell in word. Now I would like to
    >> > repeat this color in another cell. But I cannot figure out what the current

    >[quoted text clipped - 15 lines]
    >> To copy quickly from one cell to another, I believe you need a macro for
    >> that. Do you want to go that way or just do it manually?


    --
    Message posted via OfficeKB.com
    http://www.officekb.com/Uwe/Forums.aspx/word-tables/200811/1
     
    PamC via OfficeKB.com, Nov 29, 2008
    #8
  9. owyheerover

    Jamason Guest

    Re: For me, using Word 2007, the shading tab does not show the currentcolor.

    Hi

    I did a alt print scrn
    pasted the screen in to MS paint and used the color picker to select the color. You will see that it has now selected that color in the foreground color block.

    Now select Edit colors and there you will find the colours red 102, green, 232, blue 123, use this back in word or excel to use your color.

    Regards
    DarkSide

    > On Thursday, November 27, 2008 2:24 PM owyheerove wrote:


    > I have added cell shading to a table cell in word. Now I would like to
    > repeat this color in another cell. But I cannot figure out what the current
    > color is.
    >
    > The "Shading" tool does not display the current shading of the cell.
    >
    > When the cell was first shaded, the color was then displayed in the
    > "recently used colors" list. But since closing word and reopening, this list
    > is blank.
    >
    > How can I determine what the cell shading is, or copy the shading to another
    > cell?
    >
    > Thanks.
    >
    > --
    > Bill Clark
    > www.earthpoint.us



    >> On Thursday, November 27, 2008 3:51 PM JeanGuyMarci wrote:


    >> "owyheerover" wrote:
    >>
    >>
    >> If you selectt he cell, and then do Format > Borders and Shading... >
    >> Shading tab, Word will tell you the shade being used in the current cell.
    >> Just make sure to select cell(s) that all have the exact same colour.
    >>
    >> To copy quickly from one cell to another, I believe you need a macro for
    >> that. Do you want to go that way or just do it manually?



    >>> On Thursday, November 27, 2008 4:09 PM owyheerove wrote:


    >>> For me, using Word 2007, the shading tab does not show the current color.
    >>> The conditions are
    >>> 1) it is a custom color
    >>> 2) close word and reopen the file.
    >>>
    >>> You can see a picture at http://www.earthpoint.us/downloads/shading.jpg
    >>>
    >>> --
    >>> Bill Clark
    >>> www.earthpoint.us
    >>>
    >>>
    >>> "Jean-Guy Marcil" wrote:



    >>>> On Thursday, November 27, 2008 4:39 PM Doug Robbins - Word MVP wrote:


    >>>> The following will set the shading of the first table in a document to the
    >>>> shading that is applied to the cell in the first column of the first row of
    >>>> the second table in the document.
    >>>>
    >>>> With ActiveDocument
    >>>> .Tables(1).Shading.BackgroundPatternColor = .Tables(2).Cell(1,
    >>>> 1).Shading.BackgroundPatternColor
    >>>> End With
    >>>>
    >>>>
    >>>> --
    >>>> Hope this helps.
    >>>>
    >>>> Please reply to the newsgroup unless you wish to avail yourself of my
    >>>> services on a paid consulting basis.
    >>>>
    >>>> Doug Robbins - Word MVP
    >>>>
    >>>> "owyheerover" <> wrote in message
    >>>> news:...



    >>>>> On Thursday, November 27, 2008 8:38 PM Klaus Linke wrote:


    >>>>> "Jean-Guy Marcil" wrote:
    >>>>>
    >>>>> If you have done one cell, you can select another cell and hit F4, to apply
    >>>>> the same shading.
    >>>>>
    >>>>> Klaus



    >>>>>> On Friday, November 28, 2008 1:03 AM hks wrote:


    >>>>>> Klaus Linke;381011 Wrote:
    >>>>>>
    >>>>>> you can ctrl + c to cell padding which you want copy, or you block your
    >>>>>> cell padding after that copy..
    >>>>>> and paste to your word.
    >>>>>>
    >>>>>>
    >>>>>>
    >>>>>>
    >>>>>> --
    >>>>>> hks



    >>>>>>> On Friday, November 28, 2008 4:02 PM JeanGuyMarci wrote:


    >>>>>>> "owyheerover" wrote:
    >>>>>>>
    >>>>>>>
    >>>>>>> And if you click on "More Colours..."?



    >>>>>>>> On Saturday, November 29, 2008 11:19 AM PamC via OfficeKB.com wrote:


    >>>>>>>> It's too bad that W2007 is even more picky about giving up the color numbers
    >>>>>>>> than W2003 is (you can't just have the cursor in the cell; the cell must be
    >>>>>>>> selected, etc.). You've probably already noticed that as long as you are in
    >>>>>>>> the same W2007 session that the color was chosen in, it will be highlighted
    >>>>>>>> in either in the theme, standard colors, or recent colors sections of the
    >>>>>>>> shading dropdown. In later sessions, go to the reveal formatting pane
    >>>>>>>> (styles pane > style inspector (does anyone see a use for this feature?)
    >>>>>>>> button > reveal formatting button???or add the reveal formatting command to
    >>>>>>>> your QAT) to get the color number.
    >>>>>>>>
    >>>>>>>> PamC
    >>>>>>>>
    >>>>>>>> owyheerover wrote:
    >>>>>>>>
    >>>>>>>> --
    >>>>>>>> Message posted via OfficeKB.com
    >>>>>>>> http://www.officekb.com/Uwe/Forums.aspx/word-tables/200811/1



    >>>>>>>> Submitted via EggHeadCafe - Software Developer Portal of Choice
    >>>>>>>> ASP.NET MaskedTextBox Custom Control
    >>>>>>>> http://www.eggheadcafe.com/tutorial...d645/aspnet-maskedtextbox-custom-control.aspx
     
    Jamason, Oct 23, 2010
    #9
  10. owyheerover

    Dan Guest

    I ran into this same issue in Word 2010 and finally figured it out:

    1. Click in the cell you want to inspect
    2. On the Table Layout ribbon, all the way on the left click the "Select" drop-down and choose "Select Cell"
    3. Right-click on the selected cell
    4. Choose "Borders and Shading..."

    Now the Borders and Shading dialog shows the current properties of the selected cell, including Fill color on the Shading tab.

    > On Thursday, November 27, 2008 2:24 PM owyheerove wrote:


    > I have added cell shading to a table cell in word. Now I would like to
    > repeat this color in another cell. But I cannot figure out what the current
    > color is.
    >
    > The "Shading" tool does not display the current shading of the cell.
    >
    > When the cell was first shaded, the color was then displayed in the
    > "recently used colors" list. But since closing word and reopening, this list
    > is blank.
    >
    > How can I determine what the cell shading is, or copy the shading to another
    > cell?
    >
    > Thanks.
    >
    > --
    > Bill Clark
    > www.earthpoint.us



    >> On Thursday, November 27, 2008 3:51 PM JeanGuyMarci wrote:


    >> "owyheerover" wrote:
    >>
    >>
    >> If you selectt he cell, and then do Format > Borders and Shading... >
    >> Shading tab, Word will tell you the shade being used in the current cell.
    >> Just make sure to select cell(s) that all have the exact same colour.
    >>
    >> To copy quickly from one cell to another, I believe you need a macro for
    >> that. Do you want to go that way or just do it manually?



    >>> On Thursday, November 27, 2008 4:09 PM owyheerove wrote:


    >>> For me, using Word 2007, the shading tab does not show the current color.
    >>> The conditions are
    >>> 1) it is a custom color
    >>> 2) close word and reopen the file.
    >>>
    >>> You can see a picture at http://www.earthpoint.us/downloads/shading.jpg
    >>>
    >>> --
    >>> Bill Clark
    >>> www.earthpoint.us
    >>>
    >>>
    >>> "Jean-Guy Marcil" wrote:



    >>>> On Thursday, November 27, 2008 4:39 PM Doug Robbins - Word MVP wrote:


    >>>> The following will set the shading of the first table in a document to the
    >>>> shading that is applied to the cell in the first column of the first row of
    >>>> the second table in the document.
    >>>>
    >>>> With ActiveDocument
    >>>> .Tables(1).Shading.BackgroundPatternColor = .Tables(2).Cell(1,
    >>>> 1).Shading.BackgroundPatternColor
    >>>> End With
    >>>>
    >>>>
    >>>> --
    >>>> Hope this helps.
    >>>>
    >>>> Please reply to the newsgroup unless you wish to avail yourself of my
    >>>> services on a paid consulting basis.
    >>>>
    >>>> Doug Robbins - Word MVP
    >>>>
    >>>> "owyheerover" <> wrote in message
    >>>> news:...



    >>>>> On Thursday, November 27, 2008 8:38 PM Klaus Linke wrote:


    >>>>> "Jean-Guy Marcil" wrote:
    >>>>>
    >>>>> If you have done one cell, you can select another cell and hit F4, to apply
    >>>>> the same shading.
    >>>>>
    >>>>> Klaus



    >>>>>> On Friday, November 28, 2008 1:03 AM hks wrote:


    >>>>>> Klaus Linke;381011 Wrote:
    >>>>>>
    >>>>>> you can ctrl + c to cell padding which you want copy, or you block your
    >>>>>> cell padding after that copy..
    >>>>>> and paste to your word.
    >>>>>>
    >>>>>>
    >>>>>>
    >>>>>>
    >>>>>> --
    >>>>>> hks



    >>>>>>> On Friday, November 28, 2008 4:02 PM JeanGuyMarci wrote:


    >>>>>>> "owyheerover" wrote:
    >>>>>>>
    >>>>>>>
    >>>>>>> And if you click on "More Colours..."?



    >>>>>>>> On Saturday, November 29, 2008 11:19 AM PamC via OfficeKB.com wrote:


    >>>>>>>> It's too bad that W2007 is even more picky about giving up the color numbers
    >>>>>>>> than W2003 is (you can't just have the cursor in the cell; the cell must be
    >>>>>>>> selected, etc.). You've probably already noticed that as long as you are in
    >>>>>>>> the same W2007 session that the color was chosen in, it will be highlighted
    >>>>>>>> in either in the theme, standard colors, or recent colors sections of the
    >>>>>>>> shading dropdown. In later sessions, go to the reveal formatting pane
    >>>>>>>> (styles pane > style inspector (does anyone see a use for this feature?)
    >>>>>>>> button > reveal formatting button—or add the reveal formatting command to
    >>>>>>>> your QAT) to get the color number.
    >>>>>>>>
    >>>>>>>> PamC
    >>>>>>>>
    >>>>>>>> owyheerover wrote:
    >>>>>>>>
    >>>>>>>> --
    >>>>>>>> Message posted via OfficeKB.com
    >>>>>>>> http://www.officekb.com/Uwe/Forums.aspx/word-tables/200811/1



    >>>>>>>>> On Saturday, October 23, 2010 9:26 AM Jamason wrote:


    >>>>>>>>> Hi
    >>>>>>>>>
    >>>>>>>>>
    >>>>>>>>>
    >>>>>>>>> I did a alt print scrn
    >>>>>>>>>
    >>>>>>>>> pasted the screen in to MS paint and used the color picker to select the color. You will see that it has now selected that color in the foreground color block.
    >>>>>>>>>
    >>>>>>>>>
    >>>>>>>>>
    >>>>>>>>> Now select Edit colors and there you will find the colours red 102, green, 232, blue 123, use this back in word or excel to use your color.
    >>>>>>>>>
    >>>>>>>>>
    >>>>>>>>>
    >>>>>>>>> Regards
    >>>>>>>>>
    >>>>>>>>> DarkSide
     
    Dan, Oct 13, 2011
    #10
  11. owyheerover

    Guest

    On Thursday, November 27, 2008 12:24:04 PM UTC-7, owyheerover wrote:
    > I have added cell shading to a table cell in word. Now I would like to
    > repeat this color in another cell. But I cannot figure out what the current
    > color is.
    >
    > The "Shading" tool does not display the current shading of the cell.
    >
    > When the cell was first shaded, the color was then displayed in the
    > "recently used colors" list. But since closing word and reopening, this list
    > is blank.
    >
    > How can I determine what the cell shading is, or copy the shading to another
    > cell?
    >
    > Thanks.
    >
    > --
    > Bill Clark
    > www.earthpoint.us
     
    , Oct 10, 2013
    #11
  12. owyheerover

    Guest

    On Thursday, November 27, 2008 12:24:04 PM UTC-7, owyheerover wrote:
    > I have added cell shading to a table cell in word. Now I would like to
    > repeat this color in another cell. But I cannot figure out what the current
    > color is.
    >
    > The "Shading" tool does not display the current shading of the cell.
    >
    > When the cell was first shaded, the color was then displayed in the
    > "recently used colors" list. But since closing word and reopening, this list
    > is blank.
    >
    > How can I determine what the cell shading is, or copy the shading to another
    > cell?
    >
    > Thanks.
    >
    > --
    > Bill Clark
    > www.earthpoint.us


    Click on the cell that has the color you wish to copy. Right click to get to Borders & Shading. The RGB color code appears (i.e., 238,236,225). Make note of the code. Click on "More Colors" and then the "Color Sliders" symbol. While the subject cell(s) are still highlighted, input the RGB colorcodes. For example 238 for Red, 236 for Green, and 225 for Blue. Click ok and the color is then applied to the highlighted cell(s) in your document.. BTW, this is working with Word for Mac 2011.
     
    , Oct 10, 2013
    #12
  13. owyheerover

    Guest

    , Jan 16, 2014
    #13
    1. Advertisements

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Sandy Rees

    Removing shading from a table cell

    Sandy Rees, Sep 22, 2003, in forum: Word Tables
    Replies:
    1
    Views:
    111
    Peggy
    Sep 22, 2003
  2. Alan N M

    Shading in Word Table Cell

    Alan N M, Jan 14, 2004, in forum: Word Tables
    Replies:
    1
    Views:
    100
    Graham Mayor
    Jan 14, 2004
  3. George Eddon

    Shading part of the text in a table cell

    George Eddon, Jan 3, 2005, in forum: Word Tables
    Replies:
    1
    Views:
    129
    Suzanne S. Barnhill
    Jan 3, 2005
  4. Replies:
    0
    Views:
    286
  5. krohlfing
    Replies:
    3
    Views:
    292
    Anne Troy
    Jan 15, 2006
  6. Anne
    Replies:
    3
    Views:
    130
    Jay Freedman
    Jun 21, 2006
  7. editor
    Replies:
    8
    Views:
    126
    Lene Fredborg
    Jan 6, 2010
  8. M. Neves

    Table cell shading

    M. Neves, Aug 6, 2007, in forum: Word Tables
    Replies:
    1
    Views:
    107
    Lene Fredborg
    Aug 6, 2007
Loading...