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