Drop Down List that has formatting of cell range Font ect.

  • Thread starter Thread starter Tom Meacham
  • Start date Start date
T

Tom Meacham

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop Down Options 2
Conditional Format a cell that contains a function 1
Drop Down Lists 2
Change font color automatically 6
Last Modified By in a cell by user 3
cell color from drop down list 2
Drop Down List 2
Creating drop down lists with multiple options? 4

Back
Top