EXCEL TRAINING MANUAL 3.1 ADVANTAGES OF CONDITIONAL FORMATTING 3.2 HOW TO APPLY CONDITONAL FORMATTING  3.2.1 TO APPLY CONDITIONAL FORMATTING:  Page 9 GLYPH<g3> Click the Conditional Formatting command. A menu will appear with your  formatting options.  Locate the Styles group.  Select the Home tab.  Select the cells you would like to format.  Provide a better experience in Tables. Tables are a new feature in Excel 12 that I will  cover more in a few weeks, but suffice to say that they have structure and conditional  formatting takes advantage of the structure to help the user set up useful conditional  formatting rules. For example, you can create a conditional formatting rule to compare  two columns in a table or, based on a condition, format the entire row if needed.  Provide a better experience in PivotTables. We saw an opportunity for conditional  formatting to “do the right thing” when applied to PivotTables. For example, it should  be easy to apply a conditional format to an entire level and have new values that show  up inherit that format, behave sensibly when users pivot, sort, or expand/collapse, and  so on. Make the feature easier. We wanted to make it much easier for users to find the feature,  to add conditional formats to their work, and to remove them too.  Make more possible without needing to write formulas. We wanted users to be able to  set up conditions like “top 10%” and “duplicates” with just one click. Provide new “visualizations”. We wanted to provide users with new visualizations for  the purposes of exploring large data sets, identifying trends and exceptions, and quickly  comparing data. We also wanted our new visualizations to be useful for annotation and  presentation purposes. Address top customer requests. Many, many users have asked for more than three  conditions, better UI to be able to reorder rules, etc., so we wanted to address those  requests.