+ Reply to Thread
Results 1 to 6 of 6

Highlight cell on one sheet if the exact number is in a range of cells on another sheet

  1. #1
    Registered User
    Join Date
    02-08-2022
    Location
    USA
    MS-Off Ver
    365
    Posts
    16

    Highlight cell on one sheet if the exact number is in a range of cells on another sheet

    Hello All,

    Don't know why this one has stumped me, but I can't get it right and keep getting the N/A error.

    I have a row of cells on sheet one that have different values (item numbers) in Column A. Can be as few as 15, as many as 500. I have a second sheet on the same workbook that has another list of numbers (random order).

    I'm trying to conditionally format the cells on sheet 1 to highlight if that specific number appears anywhere in the range on sheet 2 (to find duplicates). I can't seem to get this right.

    Thank you!

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,986

    Re: Highlight cell on one sheet if the exact number is in a range of cells on another shee

    Hi there.

    A picture is worth 1,000 words. An Excel sheet is worth 1,000 non-editable pictures.

    Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet complete with an explanation and some expected results.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Registered User
    Join Date
    02-08-2022
    Location
    USA
    MS-Off Ver
    365
    Posts
    16

    Re: Highlight cell on one sheet if the exact number is in a range of cells on another shee

    I have attached a sample sheet. I'd like to run a conditional formatting rule that would highlight any cell on sheet: Data 1 that also shows up anywhere in column A of sheet: Data 2.
    Essentially I'm looking for conditional formatting that will highlight duplicate entries from a different sheet.
    Attached Files Attached Files

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,986

    Re: Highlight cell on one sheet if the exact number is in a range of cells on another shee

    To check. You said:

    any cell on sheet: Data 1

    do you mean ANY cell (i.e. any column), as your sample contained stuff only in column A

  5. #5
    Registered User
    Join Date
    02-08-2022
    Location
    USA
    MS-Off Ver
    365
    Posts
    16

    Re: Highlight cell on one sheet if the exact number is in a range of cells on another shee

    I apologize for the lack of clarity. Good catch. Yes, just from column A

  6. #6
    Registered User
    Join Date
    02-08-2022
    Location
    USA
    MS-Off Ver
    365
    Posts
    16

    Re: Highlight cell on one sheet if the exact number is in a range of cells on another shee

    I solved this. If anyone needs the solution it is something like this:
    (Apply conditional formatting to range of cells you are searching)

    =ISNUMBER(MATCH(A1,......))

    Fill in with the worksheet and range you are trying to match.

+ 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. [SOLVED] Find exact text in exact cell but on any sheet?
    By nobodyukno in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-12-2017, 02:59 PM
  2. Replies: 6
    Last Post: 09-08-2015, 12:30 PM
  3. Select range of cells on sheet 2 and concatenate into one cell on sheet one
    By dwachtveitl in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-13-2014, 11:59 PM
  4. Find and highlight cells in workbook that is NOT an exact match to the cell content
    By AndyHowcroft in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 08-30-2013, 12:05 AM
  5. Highlight blank cell in a selected range of a sheet
    By ROHAN999 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-20-2013, 08:50 AM
  6. [SOLVED] search for string in another sheet, get cell number and put cells in first sheet
    By 2k05gt in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-08-2011, 01:34 PM
  7. when typing to a cell check if this number exist in a range of cells (in sheet 2)
    By gtserkou in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-28-2008, 01:18 PM

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