Custom Data Validation

S

Steve E

I am trying to force a user to enter a value only if certain criteria are
present in the worksheet.

Example:
IF cells D11:D32 contain the letter "z" and IF the SUM(C37:C42)=0 I want my
user to be prompted to enter a quantity in (at least) C37 that is a whole
number.

I'm at a loss as to how to set this up.

Help?

Thanks,

Steve
 
D

Debra Dalgleish

Data validation can't force a user to enter a value in a cell, it can
only validate what they've typed in a cell.

Perhaps you could use a formula to display a message in another cell,
under those conditions, e.g.:

=IF(AND(COUNTIF($D$11:$D$32,"z"),SUM($D$37:$D$42)=0),
"Enter a value in cell C37","")

Or, use conditional formatting to black out some cells under those
conditions, using a similar formula.

Otherwise, you could use programming to check the cells and display a
message.
 
Top