Let say we want to distinguish between ordinary cells and cells with formula in it, so we give a special background color to the cells with formula.
For doing it manually is time consuming, especially on Excel Worksheet with large of cells with formula in it (usually a very complex worksheet).
The following vba macro code will do the trick for us.
Sub SelectAllCellsWithFormula()
'select all cell with formula
Cells.SpecialCells(xlCellTypeFormulas).Select
'change cell background color
With Selection.Interior
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
.ThemeColor = xlThemeColorAccent1
.TintAndShade = 0.399975585192419
.PatternTintAndShade = 0
End With
End Sub
FIN
Pingback: Number of Cells/Rows/Columns With Formula | Excel VBA Macro Tutorial and Examples
Pingback: URL
Pingback: Garden Services in North London
Pingback: how does reverse mortgage work
Pingback: reversemortgage
Pingback: whole house water filters