+ Reply to Thread
Results 1 to 7 of 7

Highlight rows with same IDs on multiple sheets

  1. #1
    Registered User
    Join Date
    06-07-2011
    Location
    Mississippi
    MS-Off Ver
    Excel 2010
    Posts
    14

    Highlight rows with same IDs on multiple sheets

    I already have certain ID's in a column highlighted on a sheet that I have been working on. I would like to highlight these same ID's throughout multiple sheets in the excel book. I am up for any suggestion if this is possible.

  2. #2
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,342

    Re: Highlight rows with same IDs on multiple sheets

    It would perhaps be an idea to post a sample of your data - obviously dummy values that are confidential but ensure that your sample is an accurate reflection of what you're working with.
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

  3. #3
    Registered User
    Join Date
    06-08-2011
    Location
    Orlando, Florida
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: Highlight rows with same IDs on multiple sheets

    If you copy the highlighted ID to a new cell, the color formatting will go with it. If you use a formula (e.g. =A3) then it will just give you the value. You can use conditional formatting wherein you can use a column on the original sheet next to your ID list specifically for highlighting. On the other sheets, where you have IDs that may or may not need highlighting, use conditional formatting to look at that column on the first page and if there is a value in the box, highlight the cell holding the ID. If I knew how your workbook was set up, it would be easier to suggest a solution. (i.e. do the highlights change periodically such as you are trying to spot different IDs at different times wherever they show up?)

  4. #4
    Registered User
    Join Date
    06-07-2011
    Location
    Mississippi
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: Highlight rows with same IDs on multiple sheets

    I made an example file so hopefully that will help. Basically if the row is highlighted in sheet1 i need the same rows highlighted in sheet2.
    Attached Files Attached Files

  5. #5
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,342

    Re: Highlight rows with same IDs on multiple sheets

    maybe

    Please Login or Register  to view this content.
    why are the cells highligted?

  6. #6
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,342

    Re: Highlight rows with same IDs on multiple sheets

    Hi spwolfe
    does sheet one have conditioal formating? ..No rules show but sheet1 does colour the cells?

  7. #7
    Forum Guru
    Join Date
    05-24-2011
    Location
    India
    MS-Off Ver
    365
    Posts
    2,243

    Re: Highlight rows with same IDs on multiple sheets

    Hello,

    See the attached with INDIRECT function & Conditional Format.
    Regards,
    Haseeb Avarakkan

    __________________________________
    "Feedback is the breakfast of champions"

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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