He didn't say it couldn't be done. He said it couldn't be done with a
formula.

However, based on your description to date, I think one would need to be a
mind reader to understand what you really want. You want to put a # in B2,
but B2 must remain blank . . .

What would trigger all this?
--
Regards,
Tom Ogilvy

"jsc3489" wrote in message
...
when either cell B1 or B3 (or both) contain nothing

B1, B2 and B3 must be allowed to remain blank for data entry

however, you've answer my question which is 'no, it can't be done'

I was afraid so.
Thank you anyway..
--
me


"Harlan Grove" wrote:

jsc3489 wrote...
....
I have a cell (B2) that is for entering data. I would like to have
another
cell (say B4)house a formula (or vb script, or ???) that

=IF(B1=""=AND(B2=""), 'leave B2 alone' , 'put a "#" character in cell
B2')
and only if B3 is blank as well

A formula in B4 can't change the entry in cell B2 except by affecting a
formula in cell B2. Are you saying you want something to replace any
entry in cell B2 with "#" when either cell B1 or B3 (or both) contain
something other than ""?