| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a way to require a cell to be completed in Excel?
I know that you can require a cell/field to be completed in Access, but was
wondering if there was a way to do the same in Excel. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Is there a way to require a cell to be completed in Excel?
I use an adjacent cell that's formatted in a big bold read font:
=if(a1<"","","<-- Please fill in this cell") dlmurray wrote: I know that you can require a cell/field to be completed in Access, but was wondering if there was a way to do the same in Excel. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Is there a way to require a cell to be completed in Excel?
Hi,
can't help on the formula's but my own method is to make the cell background bright yellow, that way people can see and pick out what they need to fill in immediately... Malcolm "dlmurray" wrote in message ... I know that you can require a cell/field to be completed in Access, but was wondering if there was a way to do the same in Excel. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Colour change in frozen colum when cell group is completed | Excel Discussion (Misc queries) | |||
| Excel Chart - Require a Formula | Excel Worksheet Functions | |||
| require cell to edit | Excel Worksheet Functions | |||
| Require Tmplwiz.exe for Excel 2003 | Excel Discussion (Misc queries) | |||
| Have cell require input before saving. | Excel Discussion (Misc queries) | |||
Hybrid Mode
