If you’re used to using older versions of Excel, you’ll be surprised by the conditional formatting options in Excel 2007, 2010, and 2013. So why would you want to use conditional formatting? Well, here are a few reasons why I love using this feature of Excel:
Excel How To: Format Cells Based on Another Cell Value Using Conditional Formatting
1. To make your data more visually appealing.
2. To make your spreadsheets understandable at a glance.
3. To identify certain types of numbers to aid in problem solving.