+ Reply to Thread
Results 1 to 4 of 4

Highlight Duplicate from one specific cell containing text

  1. #1
    Registered User
    Join Date
    10-24-2012
    Location
    during dnReoog
    MS-Off Ver
    Excel 2003
    Posts
    17

    Highlight Duplicate from one specific cell containing text

    Hello,

    I've tried doing this with conditional formatting as its standard basic function and using 'based on formula', but it's not quite behaving as I need.

    I'm rostering personnel, on various positions/stations on an event, I want to paste a name into a box and for it to highlight historically where they have been placed before. Simplified version as images below. Attached actual excel contains a version of my roster (with fake names) but more complicated than image examples as there are about 30 stations they can be placed at.
    The work pool is approx 60 ppl strong, and 30 on per shift. with staff rotating in and out of the pool on a weekly basis so to quickly see at a glance what track/position they have done before is super helpful.

    Highlight duplicates will (obviously) highlight every dup, so doesn't help me as I only want to see where one value has been placed. I tried playing around with only particular sections to dup but I can't quite get it to work.

    Is this a simple conditional format query I feel it might actually be a coding thing?

    I'm sure I've left some detail out here, please shout, Hopefully someone can help me.

    Thank you
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,466

    Re: Highlight Duplicate from one specific cell containing text

    Hightlight whole table then in Conditional Formating/ Use a formula...
    =C2=$C$34
    pick a format.
    Attached Files Attached Files
    Quang PT

  3. #3
    Registered User
    Join Date
    10-24-2012
    Location
    during dnReoog
    MS-Off Ver
    Excel 2003
    Posts
    17

    Red face Re: Highlight Duplicate from one specific cell containing text

    AH! Sensational thank you so much

  4. #4
    Registered User
    Join Date
    10-24-2012
    Location
    during dnReoog
    MS-Off Ver
    Excel 2003
    Posts
    17

    Re: Highlight Duplicate from one specific cell containing text

    Further to this - can anyone help with my next issue, I need to disable cut as it is mucking up the above formula

    (started a new thread as its a separate problem)

    but pasting here as you were a help last time

    https://www.excelforum.com/excel-pro...ml#post5494739

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Highlight specific text in a cell all at once
    By Metaldrgn in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 05-27-2020, 08:25 PM
  2. Replies: 7
    Last Post: 09-27-2019, 06:43 PM
  3. [SOLVED] Lookup specific text in a cell and highlight
    By ~TaC~ in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 09-04-2019, 03:20 AM
  4. [SOLVED] How to highlight a specific cell based on value/text/number
    By Byambadorj in forum Excel General
    Replies: 13
    Last Post: 07-18-2018, 03:41 AM
  5. [SOLVED] Highlight specific cells if cell contains text or numbers
    By besis in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-18-2018, 12:00 PM
  6. Using VBA to highlight specific text in cell
    By nav505 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-11-2013, 03:28 AM
  7. Specific Text in Range then highlight cell
    By gingank in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-11-2013, 10:41 AM

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