What is conditional formatting? In Excel, conditional formatting is the ability to apply various effects (such as color, etc.) and post-treatment for a range of cells depending on if each cell has met ...