Forum Discussion
Conditional Formatting
See attachment for Conditional Formatting question. The first attachment is incorrect please use the second attachment.
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