LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Vasant Nanavati
 
Posts: n/a
Default

Tools | Options | Error Checking | Settings | Enable Background Error
Checking

Clear the checkbox.

---------

Vasant

"Bob Newman" wrote in message
news:cn4ue.5183$up5.4912@lakeread02...
Excel 2003

I have several cells that contain IF formulas in them. If it makes any
difference they are formatted to show nothing if a referenced cell is
blank
i.e. (=IF(A7="","","Widget"). Regarding the appearance of these cells,
they
have a small indicator in the upper left (similar to the indictor to shows
that a cell contains a note). I do not want this visible (whatever it
is).
Why is it there? How do I get rid of it?
--

Thanks in advance... Bob




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
see the cells the formula relates to by double clicking the cell pvagolfer Excel Discussion (Misc queries) 1 May 16th 05 12:25 AM
trying to create an (almost) circular formula between cells and data validated cells with lists KR Excel Worksheet Functions 0 May 12th 05 07:21 PM
Macro or Formula to remove Text from Cells smck Excel Worksheet Functions 6 May 11th 05 03:22 AM
Need a 1 Column multiplication formula for 2600 cells. How? Buckle Excel Worksheet Functions 1 March 25th 05 04:17 PM
How do i select different cells to be use in a formula. Manuel Excel Discussion (Misc queries) 1 January 13th 05 03:52 PM


All times are GMT +1. The time now is 12:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"