Thanks for this tip.

I am already aware of the Display Formulas Option but I wanted something
that I could use in programming. I was presented with a 7500 line spreadsheet
with mixed formula and text/value content. It was a nightmare just looking
at. The changed background would "position" the eye easier to the cells
needing attention. Not to mention the fact that I could trap a certain
attribute or property and filter the column. I needed knowledge on
conditional range and property handling.

Thanks anyway!

" wrote:

Hey Doc

Very easy... just create the buttons, and in the code module paste this
line for viewing all the cells that contain formulas...

ActiveWindow.DisplayFormulas = True

To hide the formulas, just insert this line...

ActiveWindow.DisplayFormulas = False

Let me know if you win.


DoctorG wrote:
I want to create an On/Off button that will temporarily show which cells
contain formulas.

If someone knows a better way pls say so.

I thought of adding and then subtracting a fixed number from the
Interior.color property but I don't know how to retrieve the current value.

rngFormulas.Select
If flag = False Then
With Selection.Interior
.ColorIndex = ????? + 300000
End With
flag = True
Else
With Selection.Interior
.ColorIndex = ????? - 300000
End With
flag = False
End If