Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Blank Cells
Hi,
I'm struggling still with a problem I have. It seems simple enough but as I'm fairly new to working with spreadsheets, I can't figure it out. You know when you complete say, an online order form and if you haven't completed a field you get asked to fill it in? Well, I have to create something similar. My data is to be inputted by a user, basic stuff like Your Name, Your Company that type of thing. For a quote to be calculate though, all fields have to have either text or numbers or an option selected from a drop down. What I would like to happen is that a "Please ensure all fields are completed" box appears when a field or fields are left blank. I don't want the box to appear when the worksheet is opened, only after one or a number of fields are not completed. I hope this makes sense and I hope someone can help me out. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Index/match - make blank cells return a blank value. | Excel Worksheet Functions | |||
Quantity Blank, Remaining cells in row appear Blank | Excel Worksheet Functions | |||
Maximum Number of Blank Cells between Non Blank Cells in a Range | Excel Worksheet Functions | |||
Imported Data creates blank cells that aren't really blank | Excel Worksheet Functions | |||
Making Blank Cells Really Blank (Zen Koan) | Excel Worksheet Functions |