If you select a column, then hit F5, click special, then select formulas=>OK the cells with formulas will be selected.
Try that with your macro recorder and you should end up with a code like this.
Sub Macro1()
'
' Macro1 Macro
'
'
Columns("A:A").Select
Selection.SpecialCells(xlCellTypeFormulas, 23).Select
With Selection.Interior
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
.Color = 65535
.TintAndShade = 0
.PatternTintAndShade = 0
End With
End Sub
You can then clean up the code to look like this.
Sub ColorFormla()
Columns("A:A").SpecialCells(xlCellTypeFormulas, 23).Interior.Color = 65535
End Sub
Bookmarks