One more method which doesn't involve formulas.

Select ayour range and EditFind

What: SUM(

Find All.

With found cells dialog box open, hold shift key and scroll down to bottom of
list and select last in list.

Those cells will be highlighted.

Format them to a color for easy viewing.


Gord Dibben MS Excel MVP

On Wed, 27 Jun 2007 08:15:47 -0700, Alex Li wrote:

Say I have a spreadsheet with tons of formula, is there a way to
select (highlight) those that have the formula I specifiy? (say SUM,
AVERAGE, etc. I wanna do FDS actually for factset). Thanks.