Given what you have said, the CF Formula for cells D15:D24 should be
Formula: copy to clipboard
=$D$11="no"
Is that what you have?