Match Positive and Negatives then Highlight
Hi, everyone
I need your help to highlight cells in column with positive and negative numbers that are equals and highlight those cells then sort up cells that doesn't have color
Example:
100 <----highlight
105
-103
120 <----highlight
-100 <----highlight
110
-120 <----highlight
Will preciate your help!!!
Hi there.
I guess it's the middle of the night for you!!
I think you need to explain your problem a bit more clearly. can you post an example sheet - showing sme date, showing some cells that should be highlighted and showing WHY those particular cells should be highlighted.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
if i understood you correctly....
this might work?
Please Login or Register to view this content.
or without code....
conditional formatting,duplicate values and then filter by cell color....
as an option..
Please Login or Register to view this content.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Make headers in row 1
B2=ABS(A2)
C2=countif($B$2:$B$8,B2)
and drag down, both formula's
Then filter on c1 on criteria 1.
Then you have non duplicated cells.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
ok, my bad here's the sample file with mid and final result that i want achieve, the mainly target it's to match and highlight positive and negative numbers..
I had a look at your workbook and you appear to write your negative numbers in a somewhat unusual way.Originally Posted by werko
That confuses the VBA and it seems it may confuse you too.
I tried the below code on your data. This should color cyan all values that pair with their negative. However it only colors in cyan some of your green pairs.
Note the red line where -(value) is used as negative notation.
But if then run again with (value)- as the negative notation (as in commented blue line) it then picks up the rest, including a couple of pairs that you didn't color green. i.e. (12451 and 12451-), and (7998- and 7998).
Now, I don't know, and don't really want to know, why your method (visual inspection or other) didn't pick up those pairs. But I do think you should use a negative notation that the VBA consistently recognizes, specifically the standard Excel negative notation.
My code, run twice, second time with the notational change, does appear to pick up all pos/neg pairs according to your notation, including the ones you missed, but that's not an approach that I'd personally be happy with.Please Login or Register to view this content.
well i think that the codes will not work, first time that the codes that you provide dont work....
Wait the code from Fotis1991 it seems to work a little as he said as an option...
maybe wth some work it will work...
The code I posted worked well for me when tested on your data, subject to the other comments I made regarding how your "negative" is defined.
Usually, rather more explanation as to why a code "will not work" is useful to all readers.
What does it do that it shouldn't? What doesn't it do? What happens when you tried to run it?
If you like you can use the simple dataset - 5 pos/neg values down columnA - to test the fotis code
2
-2
5
-2
2
I wish you well!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks