View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.misc
[email protected] everythingautomotive@gmail.com is offline
external usenet poster
 
Posts: 7
Default change color of all cells with formula or are part of a formula

On Jan 27, 1:18*pm, Ron Rosenfeld wrote:
On Sun, 27 Jan 2008 10:13:16 -0800 (PST), wrote:
If D11 has formula that says "=A1+A3+B4", I want cells D11, A1, A3 &
B4 all to be shaded. *maybe I am doing something wrong but all of
this
stuff when I run the macros only shades D11 (the one with the actual
formula).


You probably were running my first recommendation, and not the most recent one:

Sub ColorFormulas()
On Error Resume Next
Cells.Interior.ColorIndex = xlNone
With Cells.SpecialCells(xlCellTypeFormulas)
* * .Interior.Color = vbYellow
* * .Precedents.Interior.Color = vbRed
End With
End Sub
--ron


no i did both. the second is definately the better of the two but it
doesn't update automatically as i am entering new formulas. in order
for it to change the cell color it seems i have to run the macro
again. i do really appreciate all your help and quick response with
this.