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).  In another post, I am going to show you how to use the And function with conditional formatting to specify formatting based on the meeting of two criteria.

 

 

Download the file to practise on here.