color cells with formulas - Page 2
Eliminate Pivot Table Annoyances
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: color cells with formulas

  1. #11
    Board Regular
    Join Date
    Feb 2002
    Location
    Athens Greece
    Posts
    149
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    thank u all for ur help and Autolycus thanx for ur remark.

    On 2002-02-26 06:29, Autolycus wrote:
    I would not recommend using this method of identifying cells with formulas.
    Cells that have this conditional formatting cannot be copied and pasted to other worksheets and attempting to do so might cause Excel to crash.

    I use these macros to identify formulas and to remove the identification :-


    Sub IdentifyFormulae_Add()
    Dim ws As Worksheet
    For Each ws In ActiveWindow.SelectedSheets
    With ws.UsedRange
    'Remove cell highlights (in case there _
    are any cells highlighted but without _
    formulae)
    .Interior.ColorIndex = 0
    'Identify Formulae
    On Error GoTo e 'Error handler if there are no formula cells
    .SpecialCells(xlFormulas).Interior.ColorIndex = 20
    End With
    Range("A1").Select
    Next
    Exit Sub
    e: MsgBox "There are no cells with formulas"
    End Sub

    Sub IdentifyFormulae_Remove()
    'Remove Identify Formulae (removes all _
    cell highlights in the selection)
    Selection.Interior.ColorIndex = 0
    Range("A1").Select
    End Sub

  2. #12
    Board Regular
    Join Date
    Feb 2002
    Location
    Athens Greece
    Posts
    149
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    THANX AGAIN. U r all very helpfull

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com