![]() ![]() Here is a very brief rundown of what each options does. The following smorgasbord of options is made available: To apply conditional formatting in Excel 2010, select the cells you want to analyse and then click Home > Styles > Conditional Formatting. What conditional formatting aims to achieve is to give you a visual way of representing your data that is more easy to take in and understand than merely presenting numbers in a spreadsheet. Excel enables you to apply formatting to cells that meet certain criteria that you specify. Or you might like to highlight sales people in your tean who have achieved more than their targets. For example, you might want to highlight sales margins on products that are less than 5%. Conditional formatting in Excel allows you to highlight cells whose data satisfies certain criteria.
0 Comments
Leave a Reply. |