Each cell can contain a formula or a value--but not both at the same time.
(Yes, the formula will evaluate to a value...)

I think I'd just fill in the "empty" cells with XXXXXXXXXX's. Then the user
will have to overwrite them to enter the real value. If they don't overwrite
them, then you'll see the x's.

Chuck N wrote:

If there is no value in F2 then "TARE ONLY" needs to show up in F2 so
that you cannot handwrite a value in over it when you print out a
certificate. I hope this makes sense.

--
Chuck N
------------------------------------------------------------------------
Chuck N's Profile: http://www.excelforum.com/member.php...o&userid=27057
View this thread: http://www.excelforum.com/showthread...hreadid=497626

--

Dave Peterson