Need to create a error message box

In my spreadsheet BC17:BC158 is a dropdown list with a chose of HB, or Blank cell.

In order for HB to be a valid selection they need to have selected Yes from a dropdown list in cell B17,D17 or F17 or any combination of "Yes" in those cells.

If not I would like an error message box to appear stating that they must first select Yes in on of the cells B17,D17,F17.

I also will need to use this synario on other column and row commbinations.

Use Data Validation with a type of Custom and a formula of
=OR(B17="Yes",D17="Yes",F17="Yes") and set the error message accordingly.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"lostinformulas"
<[email protected]> wrote in
message news:[email protected]...
>
> In my spreadsheet BC17:BC158 is a dropdown list with a chose of HB, or
> Blank cell.
>
> In order for HB to be a valid selection they need to have selected Yes
> from a dropdown list in cell B17,D17 or F17 or any combination of "Yes"
> in those cells.
>
> If not I would like an error message box to appear stating that they
> must first select Yes in on of the cells B17,D17,F17.
>
> I also will need to use this synario on other column and row
> commbinations.
>
>
> --
> lostinformulas
> ------------------------------------------------------------------------
> lostinformulas's Profile:
http://www.excelforum.com/member.php...o&userid=35229
> View this thread: http://www.excelforum.com/showthread...hreadid=560489
>

Bob,

Thanks that worked great, however orginally I had create my dropdown list using the validation:list. Using the custom I have lost the List ability unless there is a way to do both.

I would use two, one for the list, one for the custom formula, and link them
(not sure exactly how as I don't know the data and your lists).

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"lostinformulas"
<[email protected]> wrote in
message news:[email protected]...
>
> Bob,
>
> Thanks that worked great, however orginally I had create my dropdown
> list using the validation:list. Using the custom I have lost the List
> ability unless there is a way to do both.
>
>
> --
> lostinformulas
> ------------------------------------------------------------------------
> lostinformulas's Profile:
http://www.excelforum.com/member.php...o&userid=35229
> View this thread: http://www.excelforum.com/showthread...hreadid=560489
>

I would use two, one for the list, one for the custom formula, and link them
(not sure exactly how as I don't know the data and your lists).

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"lostinformulas"
<[email protected]> wrote in
message news:[email protected]...
>
> Bob,
>
> Thanks that worked great, however orginally I had create my dropdown
> list using the validation:list. Using the custom I have lost the List
> ability unless there is a way to do both.
>
>
> --
> lostinformulas
> ------------------------------------------------------------------------
> lostinformulas's Profile:
http://www.excelforum.com/member.php...o&userid=35229
> View this thread: http://www.excelforum.com/showthread...hreadid=560489
>

I would use two, one for the list, one for the custom formula, and link them
(not sure exactly how as I don't know the data and your lists).

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"lostinformulas"
<[email protected]> wrote in
message news:[email protected]...
>
> Bob,
>
> Thanks that worked great, however orginally I had create my dropdown
> list using the validation:list. Using the custom I have lost the List
> ability unless there is a way to do both.
>
>
> --
> lostinformulas
> ------------------------------------------------------------------------
> lostinformulas's Profile:
http://www.excelforum.com/member.php...o&userid=35229
> View this thread: http://www.excelforum.com/showthread...hreadid=560489
>

Bob
I had to delete all the formula to lookup information in order to get down to size.
Basically I have four tab the only two that apply to this situtation is the worksheet, and list tabs.

The list tab contains the lists, I have defined the name and used the validation rule. When I put the custom validation in it removes the list.

The Columns that apply to the list B-G have a yes/no/blank cell list
Columns BC:BD have HB/blank cell list

I hope this is enough information for you to understand what I'm trying to do.

Thanks again for your help.