What I am looking to do is create a drop down list that when it is clicked
on the options reflect the formatting of the entries in the cell range not
just the wording. For example if cell C5 is in Red font and cell C6 is in
blue font then the drop down would be in red and blue font also. It would be
even better to use the cell fill color of C5 and C6. I am setting up a form
that I would like to be able to just glance at and see what task needs to be
done next and color seemed to be the easiest way.

Thanks Tom

You could do some conditional formatting of the cell with the drop down
list. If there are more than three conditions, it would require VBA, I
believe.
"Tom Meacham" wrote in message
...
What I am looking to do is create a drop down list that when it is clicked
on the options reflect the formatting of the entries in the cell range not
just the wording. For example if cell C5 is in Red font and cell C6 is in
blue font then the drop down would be in red and blue font also. It would
be even better to use the cell fill color of C5 and C6. I am setting up a
form that I would like to be able to just glance at and see what task
needs to be done next and color seemed to be the easiest way.

Thanks Tom