Protecting cells based on values in other cells
Posted on 2014-03-21
I have a protected worksheet that is used to order software licenses. There are three types of licenses with an input cell for each type(B13,B14,B15). The license types are mutually exclusive. Because of other formula based calculations I can not use a data validation drop down list.
What I want to accomplish: When a numeric value is entered into one of the three cells the other two are locked to prevent the possibility of ordering more than one type of license.
The cell have conditional formatting to gray out other two of the cells when a value is entered into one of the cells.