1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Excel question

Discussion in 'Business Applications' started by adelaideterry, Jan 16, 2013.

Thread Status:
Not open for further replies.
Advertisement
  1. adelaideterry

    adelaideterry Thread Starter

    Joined:
    Jan 16, 2013
    Messages:
    6
    In the same workbook but using two different work sheets I want to be able to equal one cell to another work sheet but also equal its format (color) I can only equal the data in one cell to another not the color Thanks
     
  2. raybro

    raybro

    Joined:
    Apr 26, 2003
    Messages:
    5,836
    If you simply copy the cell with the unique color in one worksheet and then paste into a cell in a different worksheet, the color will transfer too.

    If you are looking for a dynamic equalization (both cell values track), then you are stuck with manually setting color on each worksheet.

    BTW... Welcome to TSG Forums... :)
     
  3. etaf

    etaf Moderator

    Joined:
    Oct 2, 2003
    Messages:
    65,252
    First Name:
    Wayne
  4. adelaideterry

    adelaideterry Thread Starter

    Joined:
    Jan 16, 2013
    Messages:
    6

    Thanks
     
  5. adelaideterry

    adelaideterry Thread Starter

    Joined:
    Jan 16, 2013
    Messages:
    6
  6. adelaideterry

    adelaideterry Thread Starter

    Joined:
    Jan 16, 2013
    Messages:
    6
    Thanks Wayne I didn't think I could do it but just had to ask someone else, Terry
     
  7. adelaideterry

    adelaideterry Thread Starter

    Joined:
    Jan 16, 2013
    Messages:
    6
     
  8. etaf

    etaf Moderator

    Joined:
    Oct 2, 2003
    Messages:
    65,252
    First Name:
    Wayne
    your welcome- you can do it with a macro that will follow any format changes and update the other cell
     
  9. adelaideterry

    adelaideterry Thread Starter

    Joined:
    Jan 16, 2013
    Messages:
    6
    Thanks Ray
     
  10. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1085599

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice