Uploaded December 2023 | Updated September 2026, 2 weeks ago
This video from our “Data to Decision” series aims at using conditional formatting to highlight items in Excel lists.
This video primarily focuses on comparing two lists to identify items that appear in either or both lists using conditional formatting. This comes particularly handy when you do not want to extract the values but to be able to visually see them in the original lists.
Learn how to highlight:
1:58 Items that are only on one list
5:00 Items in both lists
Real-World Relevance
Being able to see items in a list in comparison with another list visually is useful in a lot of applications like:
– Spotting unfulfilled orders by comparing lists of ordered versus shipped products.
– In financial statements reconciliation compare lists of transactions from two different periods or sources.
Functions you'll learn through this: COUNTIF
If you have any alternative methods for list comparison with conditional formatting, please share your thoughts in the comments below.
Check our detailed blog posts on our Data to Decisions page:
indzara.com/compare-lists-using-conditional-formatting-in-excel
To explore our fast-growing collection of free Excel tutorials covering a wide array of topics, please visit: indzara.com/datatodecisions
#exceltips #excelmadeeasy #exceltutorials
This video from our “Data to Decision” series aims at using conditional formatting to highlight items in Excel lists.
This video primarily focuses on comparing two lists to identify items that appear in either or both lists using conditional formatting. This comes particularly handy when you do not want to extract the values but to be able to visually see them in the original lists.
Learn how to highlight:
1:58 Items that are only on one list
5:00 Items in both lists
Real-World Relevance
Being able to see items in a list in comparison with another list visually is useful in a lot of applications like:
– Spotting unfulfilled orders by comparing lists of ordered versus shipped products.
– In financial statements reconciliation compare lists of transactions from two different periods or sources.
Functions you'll learn through this: COUNTIF
If you have any alternative methods for list comparison with conditional formatting, please share your thoughts in the comments below.
Check our detailed blog posts on our Data to Decisions page:
indzara.com/compare-lists-using-conditional-formatting-in-excel
To explore our fast-growing collection of free Excel tutorials covering a wide array of topics, please visit: indzara.com/datatodecisions
#exceltips #excelmadeeasy #exceltutorials
