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

Thread: How to link a cell format with another cell?

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

    Default

    I have not found this topic yet ! I would like to link a cell with another cell. Not only the value, but also the format. How can I link the format of a cell to another cell? The result will be a changed cell when I have changed the source cell. Thanx !

    --------------------------------------------------------------------------------

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sunny, spring-like Hull
    Posts
    3,339
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You could copy the cell you've linked to then Paste Special- Formats onto your destination cell. But, unless it's a conditional format, then changes to the format of the linked cell aren't updated automatically to the destination cell. Sorry I can't be of more help .

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

    Default

    thanx for the information. I think we have something Excel can work on !!

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
  •