+ Reply to Thread
Results 1 to 4 of 4

Conditional Format Needed to highlight based on matching text in certain cells

  1. #1
    Forum Contributor
    Join Date
    07-06-2013
    Location
    USA
    MS-Off Ver
    MS Office 2019 Pro Plus
    Posts
    182

    Conditional Format Needed to highlight based on matching text in certain cells

    WS attached

    I need a conditional format that will highlight in red, any duplicate text entries but only based on text from any one of 4 main cells.
    The 4 main cells are: C38, E38, G38, I38
    The bulk cells to compare are: C6:C15, C21:C32, C38, E6:E15, E21:E32, E38, G6:G15, G21:G32, G38, I6:I15, I21:I32, I38
    These 4 main cells are the ones that will have unique text in each of them. If any of these 4 cells match text with each other or if any one of the four cells match text from the bulk cells then both matching cells will highlight in red.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    05-10-2019
    Location
    Penang, Malaysia
    MS-Off Ver
    2016
    Posts
    262

    Re: Conditional Format Needed to highlight based on matching text in certain cells

    Hi excelteam777,

    Im no expert here. But let me try, please find attachment. Apologize, If this is not what you were looking for.
    Attached Files Attached Files

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

    Re: Conditional Format Needed to highlight based on matching text in certain cells

    There is no data to work with? Could you give some mockup data and up the WS again?
    Quang PT

  4. #4
    Forum Contributor
    Join Date
    05-10-2019
    Location
    Penang, Malaysia
    MS-Off Ver
    2016
    Posts
    262

    Re: Conditional Format Needed to highlight based on matching text in certain cells

    Well, there are..
    ABC, DEF, GHI, JKL from the columns. these are already with conditional formatted in red should it found any duplicate values.

+ 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. Replies: 6
    Last Post: 12-28-2021, 12:04 PM
  2. Help with conditional format to highlight partial text cells
    By ivpush33 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-07-2016, 01:40 PM
  3. [SOLVED] Conditional format help needed to highlight cells based on partially matching numbers.
    By krjoshi in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-01-2016, 12:15 PM
  4. [SOLVED] Conditional format help needed to highlight cells based on two conditions
    By krjoshi in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-28-2016, 11:35 PM
  5. Replies: 4
    Last Post: 07-25-2014, 05:17 AM
  6. Replies: 5
    Last Post: 09-05-2013, 08:59 AM
  7. Replies: 3
    Last Post: 08-28-2009, 11:16 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