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?