Conditional Formatting offers the ability to mark duplicates or uniques, but in some respects, it sort of missed the boat. Today, in Episode #1326, Bill looks at how to use a formula-based conditions with VBA to fill voids left by Condtional Formatting.

"VBA and Macros: Microsoft Excel 2010" by Bill Jelen and Tracy SyrstadFrom Chapter 15…This episode is the video podcast companion to the book, “VBA And Macros: Microsoft Excel 2010“, from Bill Jelen a.k.a. MrExcel.

For all of your Microsoft Excel needs visit MrExcel.com – Your One Stop for Excel Tips and Solutions.