Using coloured text within a Validation List

B

Big Geordie

Can you use coloured text within a validation list? I tried this and thought
that all you have too do is format the text with the list to the colour of
you choice. Well I did this but then when I went to the drop down list within
the spreadsheet, the text was normal i.e. Black text. The reason for wanting
to use coloured text is that outside the spreadsheet the items are colour
coded.
 
G

Gord Dibben

You cannot do this.

The best you can do is use Conditional Formatting to color the text after
the selection is made.


Gord Dibben MS Excel MVP
 

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

Top