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 ""?