user input question
 

I need to make a quantity cell take an input from the user if the adjacent
cell has text in it. If the adjacent cell is either blank, I need the cell
to continue to be blank regardless of what the user types in it. If the cell
had text in it and then gets erased, I need the cell to return to being blank.

Thank you,
Logan W.

Hi

You could use Format|Conditional Formatting to make the text white
(invisible) if there is nothing entered into the other cell.

Format the cell to be white text. In Conditional Formatting, use
Formula is =A2<""
and set the format to black text.
Anything that is typed in the cell will not be visible on-screen unless
there is something in the other cell - although it will appear in the
formula bar.
Andy.

"BLW" wrote in message
...
I need to make a quantity cell take an input from the user if the adjacent
cell has text in it. If the adjacent cell is either blank, I need the
cell
to continue to be blank regardless of what the user types in it. If the
cell
had text in it and then gets erased, I need the cell to return to being
blank.

Thank you,
Logan W.

Andy,
This worked until I entered something into the other cell and then deleted
it...the text still appeared. I appreciate your help.
Logan W.

"Andy B" wrote:

Hi

You could use Format|Conditional Formatting to make the text white
(invisible) if there is nothing entered into the other cell.

Format the cell to be white text. In Conditional Formatting, use
Formula is =A2<""
and set the format to black text.
Anything that is typed in the cell will not be visible on-screen unless
there is something in the other cell - although it will appear in the
formula bar.
Andy.

"BLW" wrote in message
...
I need to make a quantity cell take an input from the user if the adjacent
cell has text in it. If the adjacent cell is either blank, I need the
cell
to continue to be blank regardless of what the user types in it. If the
cell
had text in it and then gets erased, I need the cell to return to being
blank.

Thank you,
Logan W.