I've serached for about an hour so far and couldn't find an answer.
This may be a far stretch, so here goes.

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

Thank you in advance..
--
Not holding my breath


To the best of my knowlwge you cannot have one cell change another
without entering a formula into the cell to be changed.
=IF(B1&B2&B3="", "#","" will put a number chracter into the cell it
is entered in as long as cells B1:B3 are empty. If you put this
formula in cells B1, B2 or B3 you will get a "circular reference" error
and it will not work. It will work well if you put it into another cell
for example A1.


--
goober
------------------------------------------------------------------------
goober's Profile: http://www.excelforum.com/member.php...o&userid=19838
View this thread: http://www.excelforum.com/showthread...hreadid=392225