Dec 09 2021 01:20 AM - edited Dec 09 2021 03:09 PM
See attachment for Conditional Formatting question. The first attachment is incorrect please use the second attachment.
Dec 09 2021 01:34 AM
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.
Dec 09 2021 03:01 AM
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 ?
Dec 09 2021 09:08 AM
Dec 09 2021 11:55 AM
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