S
scrabtree23
How can I quickly identify all cells with a formula in
them?
them?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Paul W Smith
Tools | Options | View
Tick Formulas in Window options section
Tick Formulas in Window options section
B
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)
This toggles the setting.
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
C
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
Dim FormulaRng As Range
Set FormulaRng = ActiveSheet.UsedRange.SpecialCells(xlCellTypeFormulas)
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
G
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
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