You're welcome!

--
Biff
Microsoft Excel MVP


"BB Ivan" wrote in message
...
Great, thanks so much.

"T. Valko" wrote:

One way:

Assume you have this formatting already applied to cell A1.
Select cell A1
Goto EditCopy
Now, select the cells where you want the formatting applied.
Goto Paste SpecialFormatsOK

--
Biff
Microsoft Excel MVP


"BB Ivan" wrote in message
...
Hi Biff:
This works! Thanks. A difficulty with it, however, is that in order
to
apply it to a large range of cells I'll need to set up conditional
formatting
indivually for each cell in the range (since the formatting must know
what
address to plug into cell_ref). Can you think of any way I could
substitute
that in so I can copy the conditional formatting to other cells? I
don't
see
a function that can give me the address of the "current" cell without
being
fed reference infomation.

Thanks again!

"T. Valko" wrote:

One way...

Create this user defined function:

Open the VB editor: ALT F11
Open the project explorer: CTRL R
Locate your file name in the project explorer
Right click your file name
Select InsertModule
Copy/paste the code below into the window that opens on the right:

Function IsFormula(cell_ref As Range) As Boolean
If cell_ref.HasFormula Then
IsFormula = True
Else
IsFormula = False
End If
End Function

Close the VB editor and return to Excel: ALT Q

Select a cell that has a formula, let's use cell A1 in this example:

Select cell A1
Goto FormatConditional Formatting
Formula Is: =IsFormula(A1)=FALSE
Click the Format button
Select the Patterns tab
Select a fill color (maybe a shade of RED)
OK out

If a user deletes/overwrites the formula in cell A1 the cell will turn
RED.


--
Biff
Microsoft Excel MVP


"IvanM" wrote in message
...
I want users to be able to see where they have over-written a formula
with
text or a value (don't care which). I can't find a function that
determines
whether a cell contains a formula. Is there such a function? Or is
there
some other way to accomplish this?
thanks