MICROSOFT EXCEL 2010 Quick Reference Guide - Data Modeling & Forecasting: Conditional Formatting, Data Validation, What-If Analysis, Data Tables & Scenarios (301) Part of a series of several quick reference guides for Excel 2010, each focusing on a set of specific and important topics such as Excel 2010-201, Excel 2010-202, Excel 2010-203, Excel 2010-204, Excel 2010-301, Excel 2010-302, Excel 2010-303, Excel 2010-304, Excel 2010-401, Excel 2010-402 and much more. Use conditional formatting to enhance how your data is interpreted. Apply various conditional formatting techniques such as color, icons or data bars. Use validation when data is entered. Work with what-if scenarios and 1-var or 2-var data tables.