marker for cells containing a formula?

  • Thread starter Thread starter todd
  • Start date Start date
T

todd

That works but its not what I am thinking of. I want a
permanent mark showing in all cells containing formulas.
Excell has a small green marker in the corner of formulas
it thinks might have an error. I want a marker like that
in all my cells that have formulas. Its a feature in
Quatro Pro and I liked it. Can Excel do that?

Thanks for helping,


Todd.
 
Hi Todd!

Because you've changed the thread I risk losing what has been
suggested but from the one I've looked at you might try using:

Sub MarkFormulas()
Dim c As Range
For Each c In Selection
If c.HasFormula = True Then
c.Interior.ColorIndex = 35
End If
Next
End Sub

Put this in a module in your Personal.xls file
Then you can select a range and run the macro to give a light green
interior color to all cells in the selection with formulas in them.

But there are other approaches. If you keep in the same thread this
allows all of them to be looked at easily by those interested and
those trying to help.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Holidays and Observances Wednesday 23rd July: Armenia (Martyr's Day),
Egypt (Revolution Day), Equatorial Guinea (Bata's Fiesta), Fiji
(Constitution Day), Indonesia (National Children's Day), Oman
(National Day), Papua New Guinea (Remembrance Day), Syria (Egyptian
Revolution Day). Observances: Rastafarian (Birthday of Haile
Selassie), Neptunalia (Roman)
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Or without a loop for the activesheet

Sub test()
Cells.SpecialCells(xlCellTypeFormulas).Interior.ColorIndex = 35
End Sub
 
Back
Top