Is there any way to set up a sheet to either highlight or put a border around
a cell that is only a number and not a formula, and if possible is there a
way to turn that on and off?

Hit <F5, then click "Special".

Play with all the options that you have there.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"mrj1701" wrote in message
...
Is there any way to set up a sheet to either highlight or put a border
around
a cell that is only a number and not a formula, and if possible is there a
way to turn that on and off?

You could add simple UDF

Function IsFormula(rng As Range)
If rng.Count =1 Then
IsFormula = rng.hasformula
endif
End Function

and then use that in a Conditional Formatting formula in say cell F1

=AND($A$1<"",IsFormula(F1

which turns it on or off if A1 is empty or not.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"mrj1701" wrote in message
...
Is there any way to set up a sheet to either highlight or put a border
around
a cell that is only a number and not a formula, and if possible is there a
way to turn that on and off?