What does a red triangle mean?
Craig Schiller
I know if it appears in the upper right hand corner that it indicates a
comment in the cell.
But I have received a spreadsheet with red triangles in the upper LEFT
hand corner of some cells. What do they mean?
TIA.
Craig
Dave Peterson
that it's the error indicator (inconsistent formulas, numbers stored as text).
And the user didn't like the default color.
In xl2003 menus, it's under:
Tools|options|Error checking tab
I'd bet it's hidden under the Office Button|Excel Options -- well, somewhere!
--
Dave Peterson
Craig Schiller
Thanks for the response.
Clicking doesn't seem to do anything that I can see. As for errors, they seem to display in '07 with an exclamation mark in a triangle, no?
Dave Peterson
Try selecting the cell. Do you see a warning icon near that cell show up? If
yes, then click on that. (You don't click on the warning indicator itself
(sorry).)
--
Dave Peterson
Craig Schiller
Craig
Grace Wong
Right click in that cell, you'll see Edit Comment, Delete Comment, or Show/hide Comment.
>> On Sunday, April 25, 2010 4:39 PM Dave Peterson wrote:
>> If you click on one of them, do they indicate some sort of error? I am guessing
>> that it is the error indicator (inconsistent formulas, numbers stored as text).
>> And the user did not like the default color.
>>
>> In xl2003 menus, it is under:
>> Tools|options|Error checking tab
>>
>> I'd bet it is hidden under the Office Button|Excel Options -- well, somewhere!
>>
>> Craig Schiller wrote:
>>
>> --
>>
>> Dave Peterson
>>> On Sunday, April 25, 2010 5:59 PM Craig Schiller wrote:
>>> This is a multi-part message in MIME format.
>>> --------------050400080409080103030802
>>> Content-Type: text/plain; charset=us-ascii; format=flowed
>>> Content-Transfer-Encoding: 7bit
>>>
>>> Hi Don -
>>>
>>> Thanks for the response.
>>>
>>> Clicking does not seem to do anything that I can see. As for errors, they
>>> seem to display in '07 with an exclamation mark in a triangle, no?
>>>
>>> Dave Peterson wrote:
>>>
>>>
>>> --------------050400080409080103030802
>>> Content-Type: text/html; charset=us-ascii
>>> Content-Transfer-Encoding: 7bit
>>>
>>> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
>>> <html>
>>> <head>
>>> <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
>>> <title></title>
>>> </head>
>>> <body bgcolor="#ffffff" text="#000000">
>>> Hi Don -<br>
>>> <br>
>>> Thanks for the response.<br>
>>> <br>
>>> Clicking does not seem to do anything that I can see. As for errors,
>>> they seem to display in '07 with an exclamation mark in a triangle, no?<br>
>>> <br>
>>> Dave Peterson wrote:
>>> <blockquote cite="mid4BD4A87...@verizonXSPAM.net" type="cite">
>>> <pre wrap="">If you click on one of them, do they indicate some sort of error? I am guessing
>>> that it is the error indicator (inconsistent formulas, numbers stored as text).
>>> And the user did not like the default color.
>>>
>>> In xl2003 menus, it is under:
>>> Tools|options|Error checking tab
>>>
>>> I'd bet it is hidden under the Office Button|Excel Options -- well, somewhere!
>>>
>>> Craig Schiller wrote:
>>> </pre>
>>> <blockquote type="cite">
>>> <pre wrap="">Excel 2007.
>>> </pre>
>>> </blockquote>
>>> <pre wrap=""><!---->
>>> </pre>
>>> </blockquote>
>>> </body>
>>> </html>
>>>
>>> --------------050400080409080103030802--
>>>> On Sunday, April 25, 2010 6:35 PM Dave Peterson wrote:
>>>> The color is user selectable (at least in xl2003).
>>>>
>>>> Try selecting the cell. Do you see a warning icon near that cell show up? If
>>>> yes, then click on that. (You do not click on the warning indicator itself
>>>> (sorry).)
>>>>
>>>>
>>>> --
>>>>
>>>> Dave Peterson
>>>>> On Sunday, April 25, 2010 6:59 PM Craig Schiller wrote:
>>>>> This is a multi-part message in MIME format.
>>>>> --------------030201030202000505060607
>>>>> Content-Type: text/plain; charset=us-ascii; format=flowed
>>>>> Content-Transfer-Encoding: 7bit
>>>>>
>>>>> Ah, that did it. Thanks, Dave.
>>>>>
>>>>> Craig
>>>>>
>>>>> Dave Peterson wrote:
>>>>>
>>>>>
>>>>> --------------030201030202000505060607
>>>>> Content-Type: text/html; charset=us-ascii
>>>>> Content-Transfer-Encoding: 7bit
>>>>>
>>>>> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
>>>>> <html>
>>>>> <head>
>>>>> <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
>>>>> <title></title>
>>>>> </head>
>>>>> <body bgcolor="#ffffff" text="#000000">
>>>>> Ah, that did it. Thanks, Dave.<br>
>>>>> <br>
>>>>> Craig<br>
>>>>> <br>
>>>>> Dave Peterson wrote:
>>>>> <blockquote cite="mid4BD4C3C...@verizonXSPAM.net" type="cite">
>>>>> <pre wrap="">The color is user selectable (at least in xl2003).
>>>>>
>>>>> Try selecting the cell. Do you see a warning icon near that cell show up? If
>>>>> yes, then click on that. (You do not click on the warning indicator itself
>>>>> (sorry).)
>>>>>
>>>>> </pre>
>>>>> <blockquote type="cite">
>>>>> <pre wrap="">Craig Schiller wrote:
>>>>>
>>>>> Hi Don -
>>>>>
>>>>> Thanks for the response.
>>>>> Submitted via EggHeadCafe - Software Developer Portal of Choice
>>>>> Implementing KnownType Attribute
>>>>> http://www.eggheadcafe.com/tutorials/aspnet/a0b2da9e-aa72-457b-97a7-c377972c4a7d/implementing-knowntype-attribute.aspx
Grace Wong
Right click in that cell, you'll see Edit Comment, Delete Comment, or Show/hide Comment.
> On Sunday, April 25, 2010 4:21 PM Craig Schiller wrote:
>>> <pre wrap="">Excel 2007.
>>>>>> On Saturday, September 11, 2010 1:33 PM Grace Wong wrote:
>>>>>> It means there's a comment attached to that cell.
>>>>>>
>>>>>> Right click in that cell, you'll see Edit Comment, Delete Comment, or Show/hide Comment.
>>>>>> Submitted via EggHeadCafe - Software Developer Portal of Choice
>>>>>> Why GUIDs are not a good idea for SQL Server Primary Keys
>>>>>> http://www.eggheadcafe.com/tutorials/aspnet/d662b371-ed27-481c-aee0-ebe7cf2d9fad/why-guids-are-not-a-good-idea-for-sql-server-primary-keys.aspx
