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

Download the featured file here: docs.google.co...
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.
------------------------

[@fabiolalopez775]

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

[@MevludinShah]

Billiantly simple, thank you !

[@wayneedmondson1065]

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

[@akshaybinu7782]

Your video saved me in the right time

[@eliclemente7020]

Thank you! your video saved me so much time!

[@user-jq4ov5jn1w]

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

[@kurtagliday8804]

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

[@ChesterTugwell]

Glad it helped!

[@GV-gn3mj]

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

[@SalmanIOmrani]

this was super helpful and to the point. thank you! @ 1:29 how did you copy the formula down so quick?

[@alphalin_yt]

It's helpful! Thank you!

[@balkrishnarana5278]

Thanks for this very simple and useful information.

[@ChesterTugwell]

You are welcome!

[@prathmeshkhairnar9540]

Hi what if I want to highlight false?

[@cinos1985]

Can this be used in a budget, like say from left to right I have "goal, actual" and "difference", from top down I have, "early, spent, debt" and "saved" I need to be able to get the difference between goal and actual without having to edit for positive vs negative?

[@mumschristine]

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

[@Quran.24.7]

very very helpful, Thanks

[@foundational]

thanks a lot!!!

[@Fred-eh7lj]

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&

[@EazZieD]

yo, so this is for new customers, but how do i do the same thing but for duplicates? time sensitive if poss asap thank you so much!

[@user-fy3je7jx3f]

Is there any way to do this, but comparing two cells in the same line only to each other? For example comparing only K1=M1, K2=M2, K3=M3, etc.

[@CHRIS-tv7hf]

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

[@Rawbean23]

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.

[@333canyol777]

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.

[@Jaat_Devta_1008]

If you have got solution of this problem, please share with me also. I am also having the same problem.

[@AyushSwarnkar1611]

How formula looks like for comparing 5 sheets