I have an Excel file with Column Headers in it. I want to give this Excel file to customers and have them fill in a few rows of data.
Several columns are required. but not all are required.
How can I make several columns required in the workbook? The only validation is that the cell is not empty. I don't know in advance how many rows the customer will make. We could show a dialog box/warning, or maybe color the offending cell differently; I really don't care. Also, no VBA or Macro solutions please.
What I've tried (without solution):
- Searching Google/SuperUser
- Using Data Validation - Text length greater than zero and do not ignore blanks. Tried this at the cell level and the column level.
- Using Data Validation - Custom Formula - I can't figure out how to reference the current cell for a "=LEN(currentCell)>0" formula
Thanks in advance