Learn the basics of Excel conditional formatting in Excel 2010, Excel 2013 and Excel 2016. How to create and apply several formatting rules in Excel, how to do conditional formatting based on another cell, how to edit and copy your formatting rules.

Source: How to use conditional formatting in Excel 2010, 2013 and 2016