Excel Colour drop down box?

Question

Hello,

Does anyone know if with data validation and from here selecting 'List' instead of selecting text, if you can actually select a colour?

What I am trying to do is enable the user to go to any cell within a selected range, and when they select on the cell if then produces a drop down box, which will show a range of colours. By selecting on any of the colours will then turn that cell into the chosen colour.

I have never seen this done - yet, but looking at some answers on other excel questions I am sure some there is a clever way of doing this.

Any takers?

Answer 1

You need to know about macros to do this........The best you can do is list the colours and have a small macro attached to the dropdown box which changes the colour of the particlar cell to the one chosen on the list.



Yep marky is correct.

Answer 2

It is not strictly possible.



The best you can do is list the colours (ie red, blue, green etc) and then have a small macro attached to the dropdown box which changes the colour of the particlar cell to the one chosen on the list.



You need to know about macros to do this, but if you do is quite straight forward.

Answer 3

Create a itemizing with the three color names on a sheet someplace (suited no longer on the present sheet) provide the checklist a RangeName click on the cellular the place you pick the dropdown field information>Validation... exchange the "enable" fee to "checklist" exchange the "source" to "=ListRangeName" the place ListRangeName is the variety call you gave your checklist as quickly as you have completed this, then use the Conditional Formatting to alter the historic past/Font color for the field counting on the fee in the cellular. endure in ideas that pre-Excel 2007 you may in basic terms have a optimal of three Conditional codecs. In Excel 2007 you may have greater, i don't be conscious of if there's a optimal, yet i've got not met one yet.