Forum home » Delegate support and help forum » Microsoft Excel Training and help » ms excel training london - Green triangle

ms excel training london - Green triangle

ResolvedVersion Standard

Thu 25 Jan 2007, 16:31 Delegate Ruth said...

Ruth has attended:
Excel Intermediate course
PowerPoint Intermediate Advanced course
PowerPoint Introduction course
Excel Advanced course

Green triangle

what is the green triangle in the corner of the cell

Fri 26 Jan 2007, 10:08 Trainer Amanda said...

RE: green triangle

Hi Ruth

Thanks for your question.

The green triangle you refer to is Excel's way of indicating to you that there may be an error in the formula in that cell. If you click on the cell where the green triangle is showing then you can check to see if the formula you have entered is correct. You will also see a little icon with an exclamation mark will appear next to the cell. If you click on the icon it will allow you to select Ignore Error and the green triangle will disappear.

I hope this answers your question.

thanks
Amanda

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Colouring cells containing formulas

Cells in a worksheet can contain values or they can contain formulas. You may wish to identify all the cells in your worksheet that contain formulas by colouring those cells.

Follow these steps:
1. Choose Edit > Go To menu, or press either F5 or Ctrl+G. Excel displays the Go To dialog box.
2. Click Special. Excel displays the Go To Special dialog box.
3. Select the Formulas radio button option.
4. Select OK.

At this point, every formula cell in the worksheet is selected, and those cells can be coloured formatted as desired.

View all Excel hints and tips

ms excel training london - Green triangle

Green triangle

RE: green triangle

Excel articles

Excel tip:

Colouring cells containing formulas