Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
create self-generating numbers with letters and numbers | Excel Discussion (Misc queries) | |||
Create database in excel? | New Users to Excel | |||
quickly create extra copies of a worksheet template in a workbook | Excel Worksheet Functions | |||
need to create a formula to create a timesheet but haven't a clue | Excel Discussion (Misc queries) | |||
Create a tabular control | Excel Discussion (Misc queries) |