+ Reply to Thread
Results 1 to 4 of 4

looking matching number within same column and highlight them

  1. #1
    Registered User
    Join Date
    02-06-2013
    Location
    paris
    MS-Off Ver
    Excel 2007
    Posts
    2

    Question looking matching number within same column and highlight them

    Hello,

    In short I wrote a code that should highlight in yellow all number matching (for example 8,000.00 and (-8,000.56)) regardless of the decimals and the positive/negative sign. For the moment the code is not complete yet but it should at least highlight the same numbers, withing column H.

    The code is as follows

    Please Login or Register  to view this content.
    and this is the data in column H:

    Numbers
    3,064.03
    2,435.51
    8,037.18
    (2,435.50)
    599.82
    (8,037.00)
    10.00
    100.00

    In this case the code should highlight:
    8,037.18
    (8,037.00)
    2,435.51
    (2,435.50)

    Thank you for your help
    Last edited by xzyrus; 02-28-2013 at 09:18 AM.

  2. #2
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,710

    Re: looking matching number within same column and highlight them

    Pl see the attached file with macro.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    02-06-2013
    Location
    paris
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: looking matching number within same column and highlight them

    This is exactly what I wanted !!
    Can you just explain me:

    Please Login or Register  to view this content.
    I understood the code but I don't know what is
    Int
    Abs
    Range

    Thank you

  4. #4
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,710

    Re: looking matching number within same column and highlight them

    Int and Abs are functions.

    Int Function gives the integer part of number.

    Abs Function gives the absolute value irrespective of sign.

    IF TA=3
    Range("H" & TA) represents H3 cell.

    I hope it it is clear.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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