Is there a way to link Data and Formatting between sheets in a workbook?

Anonymous
2019-08-19T23:34:55+00:00

I have a workbook with 3 sheets.  The first sheet has 300 names in it.  The second sheet has a subset of 125 of the names.  The 3 sheet has a subset of 250 of the names.  I'd like to be able to highlight (fill) the individual names in the various cells on sheet 1 with red or yellow and have that fill color update on the corresponding names on sheet 2 or 3.  (Note: If there is a name on sheet 1 that gets highlighted and there is not a corresponding name on sheet 2 or 3, that's ok.)  Any ideas?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments
{count} votes

9 answers

Sort by: Most helpful
  1. Anonymous
    2019-08-25T23:21:45+00:00

    Hi PeterFri,

    Could you please share with us Excel file via PM. we suggest you can share via this way, upload  file into your OneDrive and share the link  with us Share OneDrive files and folders. And you can provide us link via private message.

    Note: By clicking Anyone with the link.

    Best Regards,

    Waqas Muhammad

    0 comments No comments
  2. Anonymous
    2019-08-28T08:59:24+00:00

    Hi PeterFri,

    Have you checked my above reply? Do you need further assistance?

    Best Regards,

    Waqas Muhammad

    0 comments No comments
  3. Anonymous
    2019-08-28T12:22:08+00:00

    Thank you for the follow-up, but there is no need to continue on with this at this time.  The need has been overcome by time and is no longer a priority.  You can close out this stream.

    Peter

    0 comments No comments
  4. Anonymous
    2019-08-28T23:25:05+00:00

    Hi PeterFri,

    Thanks for sharing updates information with us.

    Best Regards,

    Waqas Muhammad

    0 comments No comments