Conditional Formatting in Microsoft® Excel® 2010
Conditional formatting is a favorite feature in Microsoft Windows Excel . It allows you to specify up to three conditions and automatically change the cell formatting based on those conditions. You can also change the font, make the font bold and change the color. Conditional formatting in Microsoft Excel allows you to highlight cells whose data specifies certain criteria. That is, for example, if you want to highlight sales margins on products that are less than 5%. The aim of Conditional formatting in Microsoft Excel 2010 is to give a visual way of representing data which is easy to take in and understand than merely presenting numbers in a spreadsheet. To apply Conditional formatting in Microsoft Excel 2010 select the cells you want to analyze and then click ‘Home’, ‘Styles’, and then ‘Conditional Formatting’.
- Cross-Sheet References
- Robust Error Handling
- Performance Enhancements
In Microsoft Excel 2010 the conditional formatting can be created in references to different sheet on the workbook. This means that you no longer need to copy or link your data to the same sheet. So, as conditional formatting offers this feature you can apply it easily in organizations like bookstore.
Robust Error Handling
The range based conditional formatting such as icon sets, color scales and data bars evaluates an error. In Microsoft Excel 2007 error in the range can lead to conditional formatting not being applied to all the cells in the range which can be frustrating. So in Microsoft Excel 2010, conditional formatting ignores the errors and continues applying conditional formatting to rest of the cells in the row.
For this release the performance of formatting in Microsoft Excel 2010 has improved. For conditional formatting store the dependencies of the formulae used, so you don’t need to re-evaluate the entire conditional format. It also make the banding in the table and pivot table styles faster, so that this will impact things like refreshing a pivot table or scrolling with a large table on your sheet.