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: Software
Pingback: Digital Cameras
Pingback: Free IPad3
Pingback: wrinkles
Pingback: read about samurai grill
Pingback: scrapebox list
Pingback: jump button
Pingback: fast payday loans
Pingback: archiwizacja online
Pingback: retail design companies
Pingback: does whey protein work
Pingback: discount medical supplies
Pingback: payday loans uk
Pingback: link
Pingback: modelling agencies
Pingback: url
Pingback: gogo games
Pingback: tv live
Pingback: click for weight watchers
Pingback: the link
Pingback: Symbol LS2208 Barcode Scanner
Pingback: buy list
Pingback: servis char
Pingback: IM Lobby
Pingback: go
Pingback: promoting and celebrating Virginia creativity
Pingback: duluth tree service
Pingback: painter brisbane