Highlight value in one column if its negative value is in another column.
I have two columns of dollar values - one is an invoice amount, and the other is the amount paid. I need to be able to see which invoice dollar amounts have a corresponding negative value. For my conditional formatting, I used =COUNTIF(($B2:$B400),-($A2:$A400)) but it works inconsistently. In other words, it highlights $161.47 because there is a $-161.47, but it doesn't highlight $239.72 even though there's a $-239.72.
Re: Highlight value in one column if its negative value is in another column.
It means the value in the cell must be greater than zero. Therefore, the condition requires that both the A column cell is not blank/zero AND there is found a negative matching value in column B.
Bookmarks