Download the featured file here: [ Ссылка ]
In this video I demonstrate how to compare two columns and highlight differences using conditional formatting. This type of conditional formatting is based on a formula. In this example I use the VLOOKUP and IFNA functions to work out the differences between the two lists.
------------------------
![](https://i.ytimg.com/vi/r45PYjOjcj8/maxresdefault.jpg)