Use Conditional Formatting with Formulas to Highlight Errors, Blanks and Duplicatesīy Avantix Learning Team | Updated April 7, 2021Īpplies to: Microsoft ® Excel ® 2010, 2013, 2016, 2019 and 365 (Windows)Ĭonditional formatting is a great tool in Excel and if you combine it with formulas, you can do some amazing things.