This will make cell with =SUMPRODUCT red
If you want another 'hightlight' just record a macro as you format a cell
manually and get code from it
Adjust first line of code as needed
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

Sub myformat()
Set myrange = Range("A1:C20")
For Each mycell In myrange
mytest = mycell.Formula
mytest = Mid(mytest, 1, 11)
If mytest = "=SUMPRODUCT" Then
With mycell.Interior
.ColorIndex = 3
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
End With
End If
Next
End Sub




"Dave F" wrote in message
...
I have a large spreadsheet, comprising a range of about 100000 individual
cells, a number of which cells are running various flavors of SUMPRODUCT
calculations. Is there a macro I can write which would scan all the
cells'
formulas and highlight those cells whose formulas contain SUMPRODUCT?

Dave
--
Brevity is the soul of wit.