In this video I cover conditional formatting with icon sets and then I explain how advanced filtering with "AND" & "OR" conditions work. I also demonstrate how to record a macro to automate advanced filtering. Please comment below for your feedback.