MichaelB.
6/16/2018 - 9:52 AM

Highlight formulas in yellow

This will colour all my formulas in yellow

Sub HighlightMyFormulas()

' This will colour all my formulas in yellow

    'This code selects all formula cells resulting in a value.
    Selection.SpecialCells(xlCellTypeFormulas, 1).Select
    
    With Selection.Interior
        .Pattern = xlSolid                  'Give cells solid pattern
        .Color = 65535                      'Turns cells yellow
    End With
    
End Sub