In a previous post, I showed you how to use conditional formatting in Excel to highlight entire rows based on a specified criteria. In this post, I am going to show you how to use the AND function to conditionally format rows based on multiple criteria.

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

 

 

As always, there is a file for you to practise on.