cells with formulas

[scrabtree23]

How can I quickly identify all cells with a formula in
them?

 

[Paul W Smith]

Tools | Options | View

Tick Formulas in Window options section

 

[Bob Phillips]

or simply use Ctrl-` (that's the key to the left of the 1 on the top row.
This toggles the setting.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Chip Pearson]

You can use

Dim FormulaRng As Range
Set FormulaRng = ActiveSheet.UsedRange.SpecialCells(xlCellTypeFormulas)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Gord Dibben]

scab

Without code....Edit>Go To>Special>Formulas
Then if you have the color fill button on your toolbar..hit it.

With code......

Sub colorcells()
Dim Cel As Range
For Each Cel In ActiveSheet.UsedRange
If Cel.HasFormula Then
Cel.Interior.ColorIndex = 3 'Red
End If
Next
End Sub

Gord Dibben XL2002