Thanks for the reply, but unfortunately it didn't work. When selecting from the drop down menu the cell color changed and an option did come up to input relationship power. However, the cell turned white again when text was entered.
Is there a code to change color of the next cell?