Hi,
I am looking to see if there is a way to highlight a negative number with its corresponding positive based on the information on the other columns. Here is an example:
Col 1 Col 2 Col 3
Apple Orange -1
Apple Orange 1
Apple Banana 1

So I want excel to compare column 1 and 2 and then highlight row 1 and 2 since there is a negative and corresponding positive number on there. I dont want excel to highlight it if the numbers dont match even if column 1 and 2 have an exact match. Does that make sense?