Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get an excel field to 'prompt' me to add a number to mul.
I have a spread sheet set up. And, for the column wherein I would like
to input percentages, the percentage may vary depending on the product. It could be at 20% one day and at 30% another day. Can I get excel to 'ask me' or prompt me to input the 'percentage' based on change in product or change in day, etc???? Question: Is excel set-up to 'prompt' me to input a percentage for certain fields??? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get an excel field to 'prompt' me to add a number to mul.
OSF --
I think you can use DataValidation for this. There's one tab to specify the allowable entries -- if it's going to be a specific set of percentages (10%, 20%, but not 11%) you'll need to make a list of them and use that range to create the criterium. Then there's another tab to display a message when the cell is selected, and another tab to display the message to appear if the user puts in the wrong number. HTH. "OSF" wrote: I have a spread sheet set up. And, for the column wherein I would like to input percentages, the percentage may vary depending on the product. It could be at 20% one day and at 30% another day. Can I get excel to 'ask me' or prompt me to input the 'percentage' based on change in product or change in day, etc???? Question: Is excel set-up to 'prompt' me to input a percentage for certain fields??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Excel changing number formatting and source data in graphs on it's own!!! | Excel Discussion (Misc queries) | |||
Problems with Pivot Table Field Sorting in Excel 2002 | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) |