What it should do: Find first negative value, go down the list to find a positive match or matches, highlight all matches. Repeat for the next negative number in the list.
Should the search ignore those values that have been previously matched?
Should a different color be used for each match found?
If there are a lot of matches using the same color for all matches could just make the list the same but in color!
How is the search going to be done, what should it look for?
Search for one set of matches based on user input?
i.e. User enters -100, macro finds all records that equal 100
or i.e. Users enters -100 and macros finds all records that sum to 100
Its more complicated than imagine.