Is Conditional Protection Possible in 2003?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Les Linton - 26 Sep 2007 00:29 GMT

I have created a Sales Inventory Spreadsheet to help me as I pu
projects together that has entry fields for part number, vendor
descripiton, quantity, cost and sale price. In addition I have thre
columns with formulas for Extended Cost, Extended Sale and Profi
Margin. This all works fine. I then modified the "sale price" t
allow me to enter a number into a "Desired Margin" (DM) field and i
something is entered in that field, the sale price is calculated.

=IF(DM>0,(E4/(1-DM)), )

The ??

is there a way to protect the "Sell Price" field if a value is entere
in DM and remove protection if the DM field is cleared?

Le

--
Les Linton

Reply to this Message

ShaneDevenshire - 26 Sep 2007 03:32 GMT

Hi Les,

You could do this with VBA or if you want a weaker version you could use
Data, Validation.

Select the cell where the Sales Price calculation is and choose Data,
Validation, Custom. Enter a formula such as:

=IF(DM<>"",A10<>A10,)

Here I assume that the cell containing the DM entry if any is named DM.
Cell A10 is the location of the Sales Price calculation you want to protect.

Signature

Cheers,
Shane Devenshire

> I have created a Sales Inventory Spreadsheet to help me as I put
> projects together that has entry fields for part number, vendor,
[quoted text clipped - 12 lines]
>
> Les

Reply to this Message