macro to Highlight all cells that are formulas

[tonywatsonhelp]

Hi Everyone,
i have a sheet with loads of formulas,
all i want to do is fill each cell that has a formula with the colour RGB 130,120,70
and place as thin boarder around it in RGB 255,255,75

please help[ if you can
tony

 

[Joe4]

I would recommend trying to use Conditional Formatting, making use of the ISFORMULA function: How to use the Excel ISFORMULA function | Exceljet

 

[Fluff]

Or with VBA

Sub tonywatson()
   With ActiveSheet.UsedRange.SpecialCells(xlFormulas)
      .Interior.Color = RGB(130, 120, 70)
      .Borders.Color = RGB(255, 255, 75)
      .Borders.Weight = xlThin
   End With
End Sub

 

[tonywatsonhelp]

Thank fluff, this is great,
Joe4, nice idea but I need the cells actullly filled in not just conditionally filled for other things i want to do on the page.
Thanks
Tony

 

[Joe4]

Joe4, nice idea but I need the cells actullly filled in not just conditionally filled for other things i want to do on the page.

OK, you haven't really given us any of that detail, so we really cannot make that determination/distinction.
I am curious why Conditional Formatting wouldn't work here.