formula markers????

[Guest]

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?

 

[Guest]

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.

 

[Gord Dibben]

Bob

You can turn this feature on/off at Tools>Options>Error 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