I find that the method you describes works, but in my case it does not. The cell that I am trying to do this to is a 'merged cell' of about nine cells in the row.
For some reason the 'merged cell' does not function as a single cell in this circumstance. I would assume the logic would be the same but from what I gather it is not.

Thank you very much for all the help you provided and your time.

>>Wes