match a negative set of data with a positive set and highlight non matches

Hi ,

Im looking to compare a set of data(column) negative figures ,with a set of positive figures match the figure disregarding the negative symbol and highlight any non matched items. entries in both columns are in a random order. Hope this makes sense and someone can help

Thanks

Thanks for reply ......i am looking to compare the data in column I with data in W, were I data is negative match with a positive in column W (if I data is positive then match with negative) any non matching data to be highlighted in column z. thanks