| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If A1=X cell d1 must be completed before row 2 can be used
If the text in cell A1 = Cheque then other cells in row 1 need to be
completed, one of which must be cell D1 which will contain the cheque number before allowing row 2 to be used. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If A1=X cell d1 must be completed before row 2 can be used
hi , you can add the data validation for the rest cells
or you can add some VBA code in the selection_change event "Paul07" wrote: If the text in cell A1 = Cheque then other cells in row 1 need to be completed, one of which must be cell D1 which will contain the cheque number before allowing row 2 to be used. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Number of Completed Months | Excel Discussion (Misc queries) | |||
| Is there a way to require a cell to be completed in Excel? | Excel Worksheet Functions | |||
| Colour change in frozen colum when cell group is completed | Excel Discussion (Misc queries) | |||
| IF completed THEN invisible | Excel Discussion (Misc queries) | |||
| lock tab in sheet 2 until cell in sheet one is completed | Excel Worksheet Functions | |||
Linear Mode
