ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Green flag in cell (https://www.excelbanter.com/excel-discussion-misc-queries/179159-green-flag-cell.html)

Annie

Green flag in cell
 
Hi

Sometimes while using Excel 2003 I find that the cell is marked with a
little green flag, on the bottom lefthand corner of the cell, much like the
red flag that indicates a comment. Can anyone explain to me what this is and
what is its purpose?

Many thanks
--
Kind regards

Ann Shaw

Sean Timmons

Green flag in cell
 
These are typically in the top left, and indicate the cell appears to have a
number in it, but it's being treated as text. There should also be a yellow
diamond with an exclamation point to the left. Clcik on this and select
converr to number to get rid of the flag.

"Annie" wrote:

Hi

Sometimes while using Excel 2003 I find that the cell is marked with a
little green flag, on the bottom lefthand corner of the cell, much like the
red flag that indicates a comment. Can anyone explain to me what this is and
what is its purpose?

Many thanks
--
Kind regards

Ann Shaw


IvanM

Green flag in cell
 
You are referring to the error checking functionality. The green triangle
indicates that the cell meets one of the error situations you are set up to
check for. You can go to ToolsOptionsError Checking and select or unselect
different conditions to check for. You can also turn of error checking on
the same screen.
Hope this helps.

"Annie" wrote:

Hi

Sometimes while using Excel 2003 I find that the cell is marked with a
little green flag, on the bottom lefthand corner of the cell, much like the
red flag that indicates a comment. Can anyone explain to me what this is and
what is its purpose?

Many thanks
--
Kind regards

Ann Shaw



All times are GMT +1. The time now is 05:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com