Try:
Formula: copy to clipboard 
=COUNTIF(D2:D100,"y")/COUNTIF(C2:C100,"y")

and format as percent.

The next question is realated to the same data, byt totaly different subject - would be better to those who use http://www.excelforum.com/search.php to have them on separate threads.