I have a defined list of enquiry status which is used to define the status of
an enquiry. Currently the user picks the status easily enough by selecting
from the drop down list. However on the defined list each status has a
background cell colour to help easily identify outstanding enquiries. I would
like a way to copy this cell formatting across when the option is choosen
from the drop down list. I cant see an easy option of doing this.

Any help greatfully received.

Thanks in advance.