Restricting values in a cell that already has a dropdown list in i

[BrianMo]

I am trying to make it so that the user can not enter any information into a
cell where the value for it's criteria is 0. For example I am doing Special
Project Hours with a Special Project Hours and Code column. For any Special
Project hour column that has a number less than 1 I don't want the user to be
able to input anything. The trouble I am having is my Special Project Hours
column is a dropdown list that I created with a data validation rule. Any
help would be greatly appreciated.

Thanks in advance

 

[Bill Pfister]

Let me know if I am restating/summarizing the issue correctly:
-There is a cell (Special Project Hours) that is a data-validation drop-down
list.
-Another cell (Special Project Code) only allows user entry if Hours is
greater than 0.

If this is what you desire, you still have the Data Validation of the Code
cell. It can be a formula (that returns true or false), such as "=If(
Special_Project_Hours_cell >=0, true, false )"

Here's a simple example.
http://wcpii.com/Documents/Validation.xls

Regards,
Bill