Conditional Formatting

Occasional Contributor

See attachment for Conditional Formatting question.  The first attachment is incorrect please use the second attachment.

4 Replies


Use conditional formatting to highlight information

Excel for Microsoft 365 Excel for the web Excel 2021 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007

Use conditional formatting to help you visually explore and analyze data, detect critical issues, and identify patterns and trends.

You can find examples of solutions to do yourself in the link above.


Hope this information will help you in your projects.


I also wish you a lot of fun with Excel.



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 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