Manually combing through spreadsheets with large datasets can be a massive headache at times. Luckily, conditional formatting exists in Microsoft Excel specifically for this reason. This automation helps you visualize your spreadsheet in a completely different way, allows you to find important data quickly, and also makes your spreadsheet much more appealing to the eye. Excel even makes it easy to find – Conditional Formatting options are front and center on the Home tab.