Conditional Cell Validation

  • Thread starter Thread starter cypher
  • Start date Start date
C

cypher

I have an Excel file where I have a cell A1 that has to be YES or NO,
Simple enough, I created a drop down list.

Trouble comes in with a second cell, B1. It MUST be a percentage for
other formulas throughout the rest of the sheet to work correctly. But
this percentage value ONLY makes sense if A1 is YES, if A1 is NO, then
I need B1 to be forced BLANK, or at least to 0.00%

I am not sure how to do this.

-cypher
 
I should have clarified something. The percentage has to be user selected
from a predefined list (Validation drop-down list) from another sheet in the
workbook. I would like this drop down to be UNACCESSABLE and the cell value
to be a " " (blank space) unless A1 = YES.

Hope that more clearely demonstrates my goal. Thanks for the suggestions!!

-cypher
 
Create a range named "Zero" --
Type a zero in a cell
Select that cell
Click in the Name Box, at the left of the formula bar
Type: Zero
then press the Enter key

Create a range with your percents, named "RateList" --
Type your rates in a list in the workbook
Select those cells
Click in the Name Box, at the left of the formula bar
Type: RateList
then press the Enter key

Select cell B1
From the Allow dropdown, choose: List
In the Source box, type:
=IF(A1="Yes",RateList,Zero)
Click OK
I should have clarified something. The percentage has to be user selected
from a predefined list (Validation drop-down list) from another sheet in the
workbook. I would like this drop down to be UNACCESSABLE and the cell value
to be a " " (blank space) unless A1 = YES.

Hope that more clearely demonstrates my goal. Thanks for the suggestions!!

-cypher
Click to expand...
 
Back
Top