Learn about conditional formatting in Microsoft® Excel 2010

Conditional formatting is a feature that enables you to format a range of cells or single cell. The formatting changes can be made depending on the value of the cell or value of the formula. That means formatting will be applied to the cell only if the stated condition is met or else default formatting will be applied to the cell instead of the selected conditional formatting. An important thing to note while using conditional formatting is, it is same as adding additional formulas to each cell in which you will be using it. Therefore applying conditional formatting to a large number of cells may end up degrading the performance. So while using conditional formatting for large ranges you need to be careful.

• Cross-Sheet References
• Error Handling
• Performance Enhancements

Cross-Sheet References

Using this cross-sheet reference you don’t need to copy or link data to the same sheet. That means in order to find out the cumulative result you don’t need to go through each page individually since the last worksheet will give you the complete information of data along with the average value. As a result it makes your task easy and comfortable.

Error Handling

This error handling feature is added to Microsoft Excel 2010 in order to provide more options to users. In the previous versions, conditional formatting was not applied to the cell considering it as error in the range. Whereas in Microsoft Excel 2010, conditional formatting ignores these errors and continues to apply formatting to the remaining cells as well.

There are many performance enhancements tools in Microsoft Excel 2010 as compared to other Microsoft Excel versions. For conditional formatting the dependencies of formulas are used, so you don’t need to reevaluate the entire conditional format again. In addition to that banding in the table and pivot table performs faster so it can impact things like refreshing pivot table or scrolling through large table.

iYogi is the fastest growing online and remote tech support provider in the direct-to-consumers and small businesses sector. Our highly skilled and experienced tech experts available, 24x7x365 will provide the best issue resolution and customer satisfaction.

• Comprehensive support for conditional formatting feature in Microsoft Excel 2010
• Diagnosis & repair for your technologies
• Troubleshoot software errors
• Update drivers and security to protect against online threats
• Connect to Internet, devices, and peripherals
• Optimize your computer’s speed and performance.