Warning Message

[MLK]

Is there a way to do the following without using VBA:

If a user manually enters a value in a cell (not a list), I would like to
compare this value against a value in another column - and be able to display
a warning message if the criteria is not as expected.

For instance, if a value is entered in column A, then column B and C should
not contain any values - as this impacts connecting formulas. I could just
blank out this information - but this would impact the other calcs.
Therefore, I want to display a message to ensure the user is making the right
entries.

[pdberger]

MLK --

After you select the input cell, do the following: Click >Data>Validation.
On the 'Settings' tab, click Allow: List, and then select the range of cells
containing your acceptable entries.

HTH

"MLK" wrote:

> Is there a way to do the following without using VBA:
>
> If a user manually enters a value in a cell (not a list), I would like to
> compare this value against a value in another column - and be able to display
> a warning message if the criteria is not as expected.
>
> For instance, if a value is entered in column A, then column B and C should
> not contain any values - as this impacts connecting formulas. I could just
> blank out this information - but this would impact the other calcs.
> Therefore, I want to display a message to ensure the user is making the right
> entries.
>

[MLK]

Great! Thank you.

"pdberger" wrote:

> MLK --
>
> After you select the input cell, do the following: Click >Data>Validation.
> On the 'Settings' tab, click Allow: List, and then select the range of cells
> containing your acceptable entries.
>
> HTH
>
> "MLK" wrote:
>
> > Is there a way to do the following without using VBA:
> >
> > If a user manually enters a value in a cell (not a list), I would like to
> > compare this value against a value in another column - and be able to display
> > a warning message if the criteria is not as expected.
> >
> > For instance, if a value is entered in column A, then column B and C should
> > not contain any values - as this impacts connecting formulas. I could just
> > blank out this information - but this would impact the other calcs.
> > Therefore, I want to display a message to ensure the user is making the right
> > entries.
> >