excel validation linked to info in anothe cell.

J

jossebalthasar

Joined
Sep 19, 2011
Messages
2
Reaction score
0
Dear all,
For excell validation, I want the validation to check the presence in another cell.
So, the user may only enter a number in cell A1 if there is a value in cell B1.

How do I do this ?
Thanks !
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Red cell for negative numbers in Excel 1
Conditional Validation In Excel 1
Turning on data validation in one cell based on the contents ofanother cell 1
Data Validation - Prevent delete 2
validation help 0
Expression to Msgbox 0
Validation based on the value in another cell 7
Excel In Excel how can I block the contenent of a cell? 0

Top