Could you mean the Error warnings (in the upper left)--little (usually) green
triangles.

If yes, you can use a macro:

Option Explicit
Sub testme01()
Dim myCell As Range
Dim myRng As Range
Dim wks As Worksheet
Dim iCtr As Long

Set wks = ActiveSheet
With wks
Set myRng = .Range("f1", .Cells(.Rows.Count, "F").End(xlUp))
For Each myCell In myRng.Cells
'1 xlEvaluateToError
'2 xlTextDate
'3 xlNumberAsText
'4 xlInconsistentFormula
'5 xlOmittedCells
'6 xlUnlockedFormulaCells
'7 xlEmptyCellReferences
'8 xlListDataValidation
For iCtr = 1 To 8
With myCell.Errors(iCtr)
If .Value = True Then
.Ignore = True
End If
End With
Next iCtr
Next myCell
End With

End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

MEANLEANDEANE wrote:

Is there a way of deleting the coloured triangles from all the cells in a
column at the same time,instead of having to delete each one individually?

--

Dave Peterson