+ Reply to Thread
Results 1 to 2 of 2

Conditional formatting VBA (Pairing Value)

  1. #1
    Registered User
    Join Date
    03-07-2017
    Location
    Philippines
    MS-Off Ver
    2013
    Posts
    5

    Conditional formatting VBA (Pairing Value)

    Hi All,

    Please help

    let say this is the table: Already match the positive and negative value

    ID____Number: Value____Code____Company Name_____Date
    1____(-1409810.28)____VJ______Company 1_____Day 2
    2____1409810.28 ______VJ______Company 1_____Day 2
    3____469747.8 ______RN______Company 1_____Day 2
    4____(-469747.8) ______RN______Company 2_____Day 2
    5____(-78291.3) ______RN______Company 3_____Day 5
    6____78291.3_________RN_______Company 3_____Day 5
    7____(-38915.52)______VJ______Company 8_____Day 3
    8____38915.52________VJ______Company 8________Day 3
    9____(-14102.48)______SY______Company 1______Day 3
    10____14102.48_______SY______Company 2_______Day 2

    As you can see ID 1 and 2 have the same Number value = to zero. Highlight row to green when Company Name and date is the same "example ID 1 Company is the same to ID 2 company, Also in date
    and ID 3 and 4 highlight row into yellow when their company name and date is different to each other.
    and as you see in ID 9 and 10 has Code is SY highlight it into blue when it is SY, and the Number value is = to zero

    Many thanks in advance
    Last edited by alfie22; 03-10-2017 at 02:44 AM.

  2. #2
    Registered User
    Join Date
    03-07-2017
    Location
    Philippines
    MS-Off Ver
    2013
    Posts
    5

    Re: Conditional formatting VBA (Pairing Value)

    Here's my code for pairing Negative to positive,

    =IF(A4="","",IF(A4<0,-A4&"_"&COUNTIF(A$2:A4,A4),A4&"_"&COUNTIF(A$2:A4,A4)))

    =IF(COUNTIF(B:B,B4)=2,"x","")

    When i filter to X all pair show

+ 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. Pairing data with itself?
    By amolo in forum Excel General
    Replies: 1
    Last Post: 07-13-2016, 04:17 PM
  2. [SOLVED] Pairing people according to strengths
    By Petrus81 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 02-20-2015, 08:11 AM
  3. help pairing columns
    By YORKS12345 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-11-2014, 01:16 AM
  4. Opening xlsm files with conditional formatting opens with removed conditional formatting
    By Martijn.Steenbakker in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-07-2014, 05:38 AM
  5. Data Pairing
    By frankymute in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 01-23-2014, 01:00 AM
  6. Pinochle Tournament Pairing
    By vbianchini3 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-05-2012, 03:53 PM
  7. Random pairing
    By woodnwine in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-28-2010, 01:01 AM

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