+ Reply to Thread
Results 1 to 6 of 6

Copy font/colour/fill of cells from one sheet into another.

  1. #1
    Registered User
    Join Date
    06-04-2013
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    18

    Copy font/colour/fill of cells from one sheet into another.

    In my document i have a data entry tab. Numbers that are highlighted red = estimated, dark blue = accurate, and a red-fill cell means the data is questionable. I want this formatting to copy over into my Summary tab so people don't have to double check all the time..

    Attached is a dummied down version of my file.
    Last edited by stacesil; 06-11-2013 at 02:44 PM.

  2. #2
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Copy font/colour/fill of cells from one sheet into another.

    Where's the attachment?

  3. #3
    Registered User
    Join Date
    06-04-2013
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    18

    Re: Copy font/colour/fill of cells from one sheet into another.

    OK here is the attached document
    Attached Files Attached Files
    Last edited by stacesil; 06-11-2013 at 02:51 PM.

  4. #4
    Registered User
    Join Date
    06-04-2013
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    18

    Re: Copy font/colour/fill of cells from one sheet into another.

    Still looking for some assistance!

  5. #5
    Registered User
    Join Date
    06-04-2013
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    18

    Re: Copy font/colour/fill of cells from one sheet into another.

    Still could use some help.. or even a point in the right direction!

    Here is a more recent sample to go off of.
    Last edited by stacesil; 06-18-2013 at 07:57 PM.

  6. #6
    Registered User
    Join Date
    06-04-2013
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    18

    Re: Copy font/colour/fill of cells from one sheet into another.

    My boss is on my ***! could use some help!

+ 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