I have three columns that are dependent on one another. 

The first column contains the dropdown list: Received, Awaiting, Not Required. 

The second column consists of check boxes and the third column is % complete column. 

Is it possible to make the check box cell for a particular row blank/empty given the choice in the first column is not required ? 

The % complete column is dependent on the check box column. 

So if the check box cell is blank/empty, the % complete cell must also be empty/blank.


Are there any suggestions as to how to go about with this ?


Thank you