Hello, Excellers. Welcome to another #Exceltips #FormulaFriday blog post in my Excel 2021 series. The comparison of two Excel ranges for any differences is a common task.  One way to do this to use conditional formatting to highlight differences between the two ranges. Take a look at my two lists below. I have an original list and a new list. Let's go ahead and make the differences in these two lists stand out with conditional formatting. First I want to create named ranges … [Read more...]