+ Reply to Thread
Results 1 to 11 of 11

Capturing cell formatting as well as content

  1. #1
    Registered User
    Join Date
    11-14-2012
    Location
    Las Vegas, Nevada
    MS-Off Ver
    Excel 2010
    Posts
    5

    Capturing cell formatting as well as content

    Normally one captures the content within a cell of another cell via a very simple reference formula. For example

    Please Login or Register  to view this content.
    entered into a cell (let's say B2) will display the contents of the first cell of the Excel worksheet (A1) in the cell entered (B2).

    Is there a way to capture all of the formatting of A1 similarly and have it display in B2 as well as the content?

    I should mention that a non-VBA solution is preferred but not mandatory.
    Last edited by reggiemack; 11-14-2012 at 05:16 PM.

  2. #2
    Forum Contributor
    Join Date
    09-13-2012
    Location
    Atlanta, USA
    MS-Off Ver
    Office 2003, 2010
    Posts
    230

    Re: Capturing cell formatting as well as content

    There is a formatting paintbrush in the top left of the main tab in Excel. Just highlight a cell, click the format paintbrush, then click on or drag any cells to copy the format.

    http://spreadsheets.about.com/od/tip...at_painter.htm


    When you copy a cell, you could also right click on the destination cell, and click on paste special, then find paste formatting.
    Last edited by jake.masters; 11-14-2012 at 05:15 PM.

  3. #3
    Forum Contributor
    Join Date
    09-13-2012
    Location
    Atlanta, USA
    MS-Off Ver
    Office 2003, 2010
    Posts
    230

    Re: Capturing cell formatting as well as content

    If you're looking for a formula to do this, I do not believe it exists. As it says in this thread, the best you can do is apply the same conditional formatting to each cell.

    http://superuser.com/questions/98755...ng-in-equation

  4. #4
    Registered User
    Join Date
    11-14-2012
    Location
    Las Vegas, Nevada
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Capturing cell formatting as well as content

    Thanks Jake.

    You have confirmed my fear. I've searched hi & lo and came up up short. I need to capture the content as well as the cell formatting in 1 spreadsheet from an entirely different spreadsheet document. I guess I'll have to go the VBA route. Any ideas?

    Ciao!

  5. #5
    Forum Contributor
    Join Date
    09-13-2012
    Location
    Atlanta, USA
    MS-Off Ver
    Office 2003, 2010
    Posts
    230

    Re: Capturing cell formatting as well as content

    You need to capture the formatting of the entire sheet? Like a sort-of template?

  6. #6
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Capturing cell formatting as well as content

    Can't you just copy and paste it?

    I suspect that this could turn into quite a lot of work

  7. #7
    Registered User
    Join Date
    11-14-2012
    Location
    Las Vegas, Nevada
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Capturing cell formatting as well as content

    Quote Originally Posted by jake.masters View Post
    You need to capture the formatting of the entire sheet? Like a sort-of template?

    No. Just a couple of cells on several worksheets in a couple of workbooks. Ideally, I'd like to target the cell (workbook -> worksheet -> cell-reference) and capture the content and the formatting.

  8. #8
    Forum Contributor
    Join Date
    09-13-2012
    Location
    Atlanta, USA
    MS-Off Ver
    Office 2003, 2010
    Posts
    230

    Re: Capturing cell formatting as well as content

    I am not sure you can do that without vba. How detailed is the formatting?

  9. #9
    Registered User
    Join Date
    11-14-2012
    Location
    Las Vegas, Nevada
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Capturing cell formatting as well as content

    Quote Originally Posted by jake.masters View Post
    I am not sure you can do that without vba. How detailed is the formatting?
    I have acquiesced to the fact that it will be a VBA solution. I'd like to capture all of the formatting, including "conditional", but I'll take what I can get!!!

  10. #10
    Forum Contributor
    Join Date
    09-13-2012
    Location
    Atlanta, USA
    MS-Off Ver
    Office 2003, 2010
    Posts
    230

    Re: Capturing cell formatting as well as content

    I have to admit my VBA is extremely average...Although this sounds like a simple solution from what I know (which isn't much). If you posted this under the VBA thread just asking for some help with copying formatting, I bet someone could throw some code together pretty quickly.

  11. #11
    Registered User
    Join Date
    11-14-2012
    Location
    Las Vegas, Nevada
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Capturing cell formatting as well as content

    Quote Originally Posted by jake.masters View Post
    I have to admit my VBA is extremely average...Although this sounds like a simple solution from what I know (which isn't much). If you posted this under the VBA thread just asking for some help with copying formatting, I bet someone could throw some code together pretty quickly.
    Will do. Thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1