+ Reply to Thread
Results 1 to 4 of 4

Match values of A column with B column if condition meet then highlight

  1. #1
    Forum Contributor
    Join Date
    03-13-2013
    Location
    india
    MS-Off Ver
    excel 2010
    Posts
    378

    Match values of A column with B column if condition meet then highlight

    see in to attached file cell A1 value matching with cell B5 value only difference between that cell is 2, cell A2 matching with cell B4, cell A3 matching with cell value of B1

    cell value of A4 matching with cell value of B2 so i did not highlight that values but i highlight only those values which difference is greater than 5 but less than 10

    see cell value of A10 and B9 difference of that values is greater than 5 but less 10 so i highlight it in

    yellow color, see cell value of A19 that value not found in B column so i highlight it in red color see

    cell value of B18 that value not found in A column so i highlight it in red color,

    see cell value of A1 and cell value of B5 which difference is not greater than five and less than 10 so

    i did not highlight that value but similar value found in cell A20 but not found second time in B column

    only first time found in cell B5 but it is matching with cell A1 it means if which value found first time

    in A column and also found first time in B column match that values but same value found second time in A column

    but not found second time in B column then highlight that value vice versa do that
    Attached Files Attached Files
    Last edited by keshavtale; 03-02-2021 at 07:02 AM.

  2. #2
    Valued Forum Contributor Eastw00d's Avatar
    Join Date
    02-29-2020
    Location
    Breda, NL
    MS-Off Ver
    2016, 2019
    Posts
    808

    Re: Match values of A column with B column if condition meet then highlight

    Hi, maybe this can be a solution for you:
    Please Login or Register  to view this content.
    Cheers
    Erwin
    I started learning VBA because I was lazy ...
    Still developing.... being more lazy...

  3. #3
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    20,162

    Re: Match values of A column with B column if condition meet then highlight

    Try the attached.
    Please Login or Register  to view this content.
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    03-13-2013
    Location
    india
    MS-Off Ver
    excel 2010
    Posts
    378

    Re: Match values of A column with B column if condition meet then highlight

    Thanks now my problem is perfectly solved

+ 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. Match values of A column with B column if not match then highlight it through VBA code
    By keshavtale in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-28-2021, 04:19 AM
  2. Replies: 2
    Last Post: 10-05-2018, 08:28 AM
  3. Replies: 3
    Last Post: 08-07-2018, 10:14 AM
  4. Replies: 11
    Last Post: 08-07-2012, 03:19 PM
  5. Replies: 7
    Last Post: 09-13-2011, 12:04 PM
  6. Replies: 3
    Last Post: 08-07-2009, 12:03 PM
  7. Replies: 5
    Last Post: 08-05-2009, 02:43 PM

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