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