macro to find all formulas in a workbook

D

Dave F

Anyone have a macro that highlights all the formulas in a workbook and shades
the cell a given color?

Dave
 
G

Gary''s Student

For the active sheet in yellow:

Sub dave()
Set r = ActiveSheet.UsedRange.SpecialCells(xlCellTypeFormulas)
r.Interior.ColorIndex = 6
End Sub
 
T

Teethless mama

click F5 > Special > select Formulas > Ok > select any color you want > Enter
 
Top