Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Linking cell formats from one wrk sht to another

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    45
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have tried linking the format of one worksheet to another, by using the Format, stlye function, and it will not work. Does anyone have a clue how to do this? I linked the data, and I also want to link the format of the cells (let's say the color of the cell). It is not conditionally formatting.

    Any help would be greatly appreciated

    Thanks

  2. #2
    Board Regular Brian from Maui's Avatar
    Join Date
    Feb 2002
    Posts
    8,450
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Christal,

    Have you tried Edit/Paste Special/Formats?

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    45
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    How Obvious is that!! I am so embarrassed!!

    Thanks for the tip!!

    It worked!!

  4. #4
    New Member
    Join Date
    Apr 2002
    Posts
    45
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Well... I guess it may have been obvious, but it doesn't work. So... let me recap my problem:

    I am trying to link two spreadsheets together...., one spreadsheet that I input information into one, and the other that is updated automatically. The data gets updated, but the format of the cell doesn't, ie. color, etc.

    I did cut and paste special: didn't work

    I did Refresh All: didn't work

    I opened both files and save them both: didn't work

    I am lost! Anyone have any ideas??

    Frustrated!!

    Thanks!

    [ This Message was edited by: christal on 2002-05-06 05:49 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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