advantages of using conditional formatting in MS Excel 2010
Answers
Answer:
Conditional formatting is a way of formatting cells in the spreadsheet software Microsoft Excel. It allows cells within a particular spreadsheet to be formatted automatically in accordance to what is in the cell. For example, if there is a figure that is negative in a cell, the cell color would automatically turn to red, positive numbers may turn the cell green and so on. So what are the advantages of conditional formatting?
Updates occur in real time
The spreadsheet will have the ability to format itself as you are working on it in real time. This means that anything you do within the spreadsheet will be brought to your attention quicker if the cells were to change their format. For example, if you have entered the same data into the spreadsheet twice, you could set up conditional formatting to change this cell to red. That way you are constantly up to date with everything that is going on in your spreadsheet.
Answer:
Explanation:conditional formatting makes easy to find values under our big data
It makes easy to find and read in spreadsheet