| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
In Excel, how can I require a field to contain data?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
In Excel, how can I require a field to contain data?
Data Validation could be used.
Select B1 and Data ValidationCustom =COUNTA(A1)0 Add an error alert "A1 must be filled before entering data in B1" Gord Dibben MS Excel MVP On Tue, 21 Jul 2009 14:06:01 -0700, mswanson wrote: |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation- Require Entry in a Field | Excel Discussion (Misc queries) | |||
| How do I require data entry in a cell before moving to the next ce | Excel Worksheet Functions | |||
| IS THERE A WAY TO HAVE CELLS IN AN EXCEL SPREADSHEET REQUIRE DATA? | Excel Worksheet Functions | |||
| Data calculations require more than 7 nested functions | Excel Worksheet Functions | |||
| Data calculations require more than 7 nested functions | Excel Worksheet Functions | |||
Linear Mode
