Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compulsory cells
Does anyone have any ideas how to make a cell compulsory if the cell next to
it has been filled in? Can't see how to do it through validation. Don't want to use VBcode as you can disable this when opening the file. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compulsory cells
I'd use a formula in another cell. Then format it in nice big, bold, red
letters: =if(and(a1="",b1<""),"Please put something in A1","") Chris wrote: Does anyone have any ideas how to make a cell compulsory if the cell next to it has been filled in? Can't see how to do it through validation. Don't want to use VBcode as you can disable this when opening the file. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need to paste link from 4 vertical cells to 4 horizontal cells? | Excel Discussion (Misc queries) | |||
Merge Cells | Excel Discussion (Misc queries) | |||
Use the Merge & Center Button with unprotected Cells - sheet prote | Setting up and Configuration of Excel | |||
Help adding text values | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |