#1   Report Post  
Old Bob
 
Posts: n/a
Default formula markers????

I now have office 2003 with xp sp2 and I see small green markers on cells
where there is a formula on SOME of my spreadsheets. This is a nice feature
but they do not appear on all my spreadsheets--why? Where is this neat
feature controlled?
  #2   Report Post  
 
Posts: n/a
Default

hi,
it is not exactly controled. it's built in. these markers
are warnings or information about your formulas. warnings
about incosistance formula in a columns and other stuff.
if excel sences that nothing is wrong with the
formual....no marker. if you right click the marker, you
will get a popup menu which you can click ignore warnings.

-----Original Message-----
I now have office 2003 with xp sp2 and I see small green

markers on cells
where there is a formula on SOME of my spreadsheets.

This is a nice feature
but they do not appear on all my spreadsheets--why?

Where is this neat
feature controlled?
.

  #3   Report Post  
Gord Dibben
 
Posts: n/a
Default

Bob

You can turn this feature on/off at ToolsOptionsError Checking.

It is a global setting so all workbooks with errors will show the triangle.

If no perceived errors or inconsistencies, Excel will not show the triangles.

e.g. enter '1 and Excel will tell you this looks like a number but you have
entered it as text.


Gord Dibben Excel MVP



On Mon, 7 Mar 2005 10:01:41 -0800,
wrote:

hi,
it is not exactly controled. it's built in. these markers
are warnings or information about your formulas. warnings
about incosistance formula in a columns and other stuff.
if excel sences that nothing is wrong with the
formual....no marker. if you right click the marker, you
will get a popup menu which you can click ignore warnings.

-----Original Message-----
I now have office 2003 with xp sp2 and I see small green

markers on cells
where there is a formula on SOME of my spreadsheets.

This is a nice feature
but they do not appear on all my spreadsheets--why?

Where is this neat
feature controlled?
.


Reply
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
IF & VLOOKUP FORMULA taxmom Excel Worksheet Functions 3 March 2nd 05 04:35 PM
Problem with VBA returning the contents of a long formula. [email protected] Excel Discussion (Misc queries) 2 February 23rd 05 01:14 AM
Match / Vlookup within an Array formula Hari Prasadh Excel Discussion (Misc queries) 3 February 3rd 05 05:37 PM
Relative Indirect Formula Referencing? Damian Excel Worksheet Functions 1 January 7th 05 05:16 AM
Help with macro formula and variable Huge project Excel Worksheet Functions 0 December 28th 04 02:27 AM


All times are GMT +1. The time now is 06:31 PM.

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

About Us

"It's about Microsoft Excel"