Tuesday, April 19, 2011

Error Indicating Color in MSExcel 2003

Microsoft Excel reports an error with a color on the top of the cell where it finds an error. we can change the color of it as well.  Now we will see how we can change the color of error reporting in Excel 2003. 


Steps to Change the error reporting color in Microsoft Excel:

1) Click on Tools and Options


2) Click on the tab Error Checking.
 


3) By default we see a green color as Error Indicator Color. Now we have changed it to red to see the Error Indicator as red. 

4) Now on the excel sheet if we make an error in writing a formula or a function, we see a red indicator above that particular cell.


We see that the formula to add the cells has an error with an extra 'b' in the end.  



0 comments:

Post a Comment

Search This Blog

Followers

Related Posts Plugin for WordPress, Blogger...
Twitter Delicious Facebook Digg Stumbleupon Favorites More