Sorry for the confusion in how I have been wording my issue. If it is possible, I would like to have my formula in the attached document from my previous post to only apply to the four of the five selections within the dropdown box (I want the "Open" selection to not have any formula attached to it so I can enter in my own info.) I would also like the formula to re-apply if I would choose to go from the "Open" selection to any of the other selections where the formula would apply again.

Hope this is easier to understand!