In this video, I am going to show you how to use conditional formatting to highlight an entire row based on a single criteria (rather than just highlighting the single cell).
We are also going to look at how you could create a dropdown to highlight different entries. We are going to use the Unique() function to make this list fully dynamic combined with the Sort() function to ensure it is always in alphabetical order.
You can download the completed file here