Compare Two Columns in Google Sheets and Highlight Differences Using Conditional Formatting

Thank you for this very helpful information. I will need to tweak it a bit so I can do groups of text but I think I have that sorted. I am a little confused about the labels though . . . The question in the Spend/Feb data is "Exists in January?" Why are the ones that do exist reading False? 

For example, Customer "No Management Here and Co" IS in "Spend/Jan" and IS in Spend/Feb but in the column you created, "Exists in January?" it states "False" when clearly it does exist in January? I get that you are just trying to notate new companies but the wording (logic?) seems backwards to me.

Sir, thank you for the tutorial, you have saved my corporate life. 🤓

Thank you! I've been looking for hours for a way to accomplish this. This was the only tutorial that helped me.

Your video saved me in the right time

How about when comparing to more than 2 columns? in which each column to compare has a different color

Thank you! So true means the value is not twice?

Billiantly simple, thank you !

This is a ife saver!!! Thank you!!!

How formula looks like for comparing 5 sheets

thanks a lot!!!

Hi what if I want to highlight false?

Thanks for this great tutorial! Is there a way to be more permissive and allow partial match (if, as an example, some characters are slightly differents)? Also, is the a way to get a link to the matche so you can find it easely if there is a lot of lines/datas&

Thank you for your video! Is there any way to compare more than 2 columns? I have 4 columns in which numbers should match. If all four numbers are equal, it's true otherwise (if at least 1 out of 4 do not match) is false. Ideally to make it with conditional formatting to color in green if true and in red if false.

how do you highlight whole row of a match result instead of just one cell?

It's helpful! Thank you!

Nice one Chester! Thanks for demonstrating this technique. Thumbs up!!