Conditional Formatting is a great way to create dashboards in Excel that automatically change colors and icons based on your data. Conditional Formatting is also very helpful when reviewing new data. You can quickly and easily focus on the most important trends or outliers in your data. Watch this series of Excel Videos and read the four articles below, then test your knowledge with the sample spreadsheet used in the articles. By the time you finish, you’ll be well on your way to mastering Conditional Formatting.