I need to set it up that if they put in a certain date for an "actual end
date" for an action and it is equal to the "Planned Action End Date for open
actions" they will then get a drop down list for the question will this
"action become a control" which they can only answer yes or no to based on
the above being satisfied.

From this if the answer is yes the text in the "action" cell will be added
to the controls cell, put in a cell for "closed actions" and also the "actual
end date" will feed into a "End date for closed actions" cell.

If the answer is no the text in the "action" cell will only be added to the
"closed actions" cell and "End date for closed actions" cell.

Is this possible?