The answer is pretty much No - a cell either contains a formula or it
contains something other than a formula. If a cell starts out containing a
formula and someone just types stuff into that cell, the formula is deleted
and whatever they typed stays behind.

Now, if you are talking about people typing into column A when there's not a
Y in a cell, we can do this kind of thing with an IF formula in column B.

Maybe an example will help you. Given the layout you've shown, put this
formula in B3:
=IF(A3="Y",$B$1,A3)
That says "if cell A3 contains a Y, then display the contents of cell B1
(always B1 because the $ symbols lock the reference) but if A3 doesn't
contain "Y" then echo whatever is in A3 here in B3.

But if someone types into B3, then the formula is going to go bye bye.


"kvnexcel" wrote:

Can a formula print a result in a target cell, one that doesn't have a
formula itself because it also may be used for text entry?
I want users to be able to type text into cells in the B column. The
exception is, when there is a Y in an A-column cell, I want B1's content (in
this case, "RED") to be copied into target cell B3. The Y is the controlling
factor -- if it's there, B3 says RED; if the Y is not there, the user can
enter own text.
Is this dual-nature B3 possible? It seems like the answer may be an
IF in another cell that prints a result into B3. Like in the movie `Broadcast
News,' I `say it here and it comes out there.'
A B
1 RED
2
3 Y