CONDITIONAL FORMATTING BY ROW

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.

[flowplayer src=’https://s3-eu-west-1.amazonaws.com/the-excel-expert/conditional_formatting_row.m4v’]

Download the file to practise on here.