How to create condition for a required field

[Over_My_Head]

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel I have an order form and I want to set up a requirement that if the price column has a price in a cell then the ship date column must have a date in the same row as the price in order to print or save the worksheet

 

[John McGhie]

Let's assume that the Price is in cell E8 and the Ship Date is in F8.

Set the Data Validation for cell E8 to Custom and enter the formula =F8<>""

That will pop up an alert any time someone tries to enter anything in cell
E8 while F8 is blank.

See the Excel help topic "Restrict data entry" for more ...

Cheers

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel I
have an order form and I want to set up a requirement that if the price column
has a price in a cell then the ship date column must have a date in the same
row as the price in order to print or save the worksheet

--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:[email protected]

 

[Over_My_Head]

Let's assume that the Price is in cell E8 and the Ship Date is in F8.

>
> Set the Data Validation for cell E8 to Custom and enter the formula =F8&quot;&quot;
>
> That will pop up an alert any time someone tries to enter anything in cell
> E8 while F8 is blank.
>
> See the Excel help topic &quot;Restrict data entry&quot; for more ...
>
> Cheers
>
>
> On 22/03/10 3:38 AM, in article (e-mail address removed)2ac0,
> &quot;[email protected]&quot; wrote:
>
>
> --
>
> The email below is my business email -- Please do not email me about forum
> matters unless I ask you to; or unless you intend to pay!
>
> John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
> McGhie Information Engineering Pty Ltd
> Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:[email protected]
>
> John:

Many Thanks

 

[John McGhie]

That's interesting: The web server munched the symbols from that formula.

The validation should be =F8 <> ""

Equals F8 is not equal to nothing.

Sorry about that!

Cheers

Many Thanks

--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:[email protected]