Results 1 to 5 of 5

Match positive and negative values with the same assignment/reference

Threaded View

  1. #1
    Registered User
    Join Date
    09-10-2012
    Location
    Lund
    MS-Off Ver
    Excel 2003
    Posts
    9

    Match positive and negative values with the same assignment/reference

    Hi all,

    I want to match (highlight cells) positive and negative values per assignment. So in column A you have the assignment (ex. 1, 2, 3, 4 and 5), and in column B you have the values. So if the rows have the same assignment and have the values -5000 and 5000 they should get highlighted. But I cannot figure out any way to make this work properly with conditional formatting. But if there are two rows with the same assignment with the values of -5000 and 4000 they should not be highlighted. I have attached an example.
    example.xlsx

    Many thanks for your help, I hope this problem is possible to solve!

    Best Regards,
    Nicklas
    Last edited by nicklasj; 09-10-2012 at 03:18 PM. Reason: Solved

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