How to compare two lists in Excel using Conditional Formatting - Excel Tips and Tricks - video Dailymotion

ExcelTips247

Discover how to compare two lists to find missing values in Excel using Conditional Formatting. This will essentially answer, question like "How do I compare two missing data lists in Excel?", "How to compare two lists in Excel using conditional formatting?", "How do I find missing values in two Excel spreadsheets?" or "How do I compare two lists in Excel for differences?"   Excel is a powerful tool for managing data, but it can be challenging to compare two lists and identify any missing values. Manually scanning through large datasets can be time-consuming and prone to errors. However, using Conditional Formatting, Excel provides a simple and efficient solution to identify any missing values between two lists. By applying this technique, users can quickly compare two lists and visually highlight any discrepancies. This guide will walk you through the steps to compare two lists and identify missing values in Excel using Conditional Formatting.   Identify Missing Names  1) Select names in Column A (A2 to A27)  2) Home ~ Style ~ Conditional Formatting  3) New Rule...  4) Select "Use a formula to determine which cells to format".  5) =COUNTIF($B:$B, $A2)=0  6) Format  7) Fill tab  8) Select color  9) OK  10) OK   Here is the link to my previous YouTube Video on "How to compare two lists to find missing values in excel".  https://youtube.com/shorts/dl75Lz_jaPs?feature=share  I was using this formula  =FILTER(A2:A27,NOT(COUNTIF(B2:B19,A2:A27)))   🔗🔗 LINKS TO SIMILIAR VIDEOS 🔗🔗  How to compare two lists to find missing values WITHOUT FORMULA in excel - Excel Tips and Trick  https://youtube.com/shorts/pJtB8dbbimw?si=iL8qnDJ_WVAhKhAX   Compare two lists to find missing values using XLOOKUP in Excel - Excel Tips and Tricks  https://youtube.com/shorts/nOwMXkZJ5HU?si=N80igNW7Vr-xCK5x   Compare two lists to find missing values using VLOOKUP in Excel - Excel Tips and Tricks  https://youtube.com/shorts/1XGIPzsvS_Y?si=cu3ajNdT3lXFX3LB   How to compare two lists in Excel using Conditional Formatting - Excel Tips and Tricks  https://youtube.com/shorts/GX-BYEgcnRA?si=16oLe6kcxZExM4Df   How to compare two lists to find missing values in excel - Excel Tips and Tricks  https://youtube.com/shorts/dl75Lz_jaPs?si=-UTAvmCRdTl6ZZgm   Excel Tips and Tricks - Compare Two Lists In Excel And Highlight  https://youtube.com/shorts/xJoy-nboV6A?feature=share   Summarize Duplicates in Excel - Excel Tips and Tricks  https://youtube.com/shorts/-IYUTWVmVTU?si=aN-hfbyQD0QEPcgm   Find difference quickly in Excel Comparing 2 List - Excel Tips and Tricks  https://youtube.com/shorts/8_-lN-yKf04?si=itTI-rcCKOaG7zVc   How do I compare two missing data lists in Excel?,How to compare two lists in Excel using conditional formatting?,How do I find missing values in two Excel spreadsheets?,How do I compare two lists in Excel for differences?,  How to compare two columns for (highlighting) missing values in Excel?,

Transcript

00:00In my previous video, I illustrated how to compare two lists using filter and count if function.

00:05However, if the Excel version you are working with does not include filter function,

00:09you can still accomplish the same task by employing conditional formatting.

00:13The first thing to do will be select your main data set like this.

00:17And after that, go home, style, conditional formatting, and new rule.

00:22In this new rule, you'll be selecting use formula and this is the formula you'll be using.

00:26Once that's done, click on format and make sure you're on fill tab.

00:31I'm going to select say yellow and click OK.

00:35Once that's done, click OK and you can see that all the names that appear on column A

00:41but not in column B are highlighted in yellow.

How to compare two lists in Excel using Conditional Formatting - Excel Tips and Tricks

Category

Transcript

Comments

Recommended