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=’′]



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