Forum Discussion
Conditional Formatting
See attachment for Conditional Formatting question. The first attachment is incorrect please use the second attachment.
Could you please clarify a bit. On the one hand you'd like to highlight unique values for both columns. On the other hand in explanations you'd like to highlight 200 in A since it's not in column B. But it's not unique, we have it 2 times in A
So, unique for both columns, or values in one column which are not in another column ?
Even though the 200 is a duplicate and not a unique value in the first column it is not in the other column and since it is not in the other column, I want the 200 to be highlighted twice. The "200 is unique to the first column...it is just in there twice.
If so you may apply to range in column A conditional formatting rule with formula
=NOT( COUNTIF($B$2:$B$7, A2) )and similar to B