Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF & VLOOKUP FORMULA | Excel Worksheet Functions | |||
Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
Help with macro formula and variable | Excel Worksheet Functions |