Download the featured file here: https://docs.google.com/spreadsheets/d/1NTC8h4L--15o1J5B4XDxAMD3zwnbKxMGul0Vw9RQW6s/edit#gid=0 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. ------------------------