Input of Data required based on another cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bluegrassstateworker - 05 Dec 2007 15:55 GMT

I have a cell that I wish to require have a value entered if the cell
before it contains a specific value. In this case, the cell values
are either "1-Yes" or "0-No". Using the Left() function, I can obtain
either a 1 or 0 value. In an adjacent cell, if someone has selected
"1-Yes" from the dropdown list I want to make sure that the user must
input information before going on. An analogy would be a question/
answer sequence: "Are you working on anything?" "Yes." "Enter what you
are working on in the cell below."

I can do this via visual basic and setting a variable to handle this
but I would rather keep it within Excel funtions before I do this.

As always, asisstance most appreciated.

Reply to this Message

CLR - 05 Dec 2007 16:17 GMT

I know of no way you can force the issue without using VBA. One thing you
could do, is use Conditional Formatting to pop up a red background and show
the white font in the cell stating your "Message" requiring that cell be
populated next. You could also IF your other formulas to not work unless the
required cell contains data.

hth
Vaya con Dios,
Chuck, CABGx3

> I have a cell that I wish to require have a value entered if the cell
> before it contains a specific value. In this case, the cell values
[quoted text clipped - 9 lines]
>
> As always, asisstance most appreciated.

Reply to this Message