Customise validating data

[ctvu]

Hi all

I would like to know how I can customise the validating data.
For example:
From the list I want to create like below:
Mon (yellow colour)
Tue (blue colour)
Wed (red colour)
And I change the font and colour each of them.
After everything is done. I only see black font from the drop-donw list.

Is there any way to achieve this?

Thank you in advance

 

[stanleydgromjr]

ctvu,

Try this link to get you started with conditional formatting.
http://www.mrexcel.com/forum/showthread.php?t=327846


Have a great day,
Stan

 

[ctvu]

ctvu,

Try this link to get you started with conditional formatting.
http://www.mrexcel.com/forum/showthread.php?t=327846


Have a great day,
Stan

Thank you Stan

I gave it a go. but maybe I did something wrong, it is not working.

cheers

 

[ctvu]

Thank you Stan

I gave it a go. but maybe I did something wrong, it is not working.

cheers

Further to this.

I could do the conditional formatting (colour text and cell) on the list. But they are still the same from the drop-down list.
However when I applied the conditional formatting for the worksheet then, I can see it changes colour accordingly.
Is it how it is supposed to be?

thanks again

 

[stanleydgromjr]

ctvu,

Please post a screenshot of your sheet(s), what you have and what you expect to achieve, with Colo's HTML Maker.
http://www.puremis.net/excel/downloads.shtml

Instructions for using "Colo's HTML Maker":
http://www.mrexcel.com/forum/showthread.php?t=89356


Or, with Excel Jeanie HTML 4.
http://www.excel-jeanie-html.de/index.php?f=1

Instructions for using "Excel Jeanie HTML 4":
http://www.excel-jeanie-html.de/html/hlp_schnell_en.php


Have a great day,
Stan

 

[ctvu]

ctvu,

Please post a screenshot of your sheet(s), what you have and what you expect to achieve, with Colo's HTML Maker.
http://www.puremis.net/excel/downloads.shtml

Instructions for using "Colo's HTML Maker":
http://www.mrexcel.com/forum/showthread.php?t=89356


Or, with Excel Jeanie HTML 4.
http://www.excel-jeanie-html.de/index.php?f=1

Instructions for using "Excel Jeanie HTML 4":
http://www.excel-jeanie-html.de/html/hlp_schnell_en.php


Have a great day,
Stan

Thank you Stan for your great help, apparently all users are happy with what I have done, as long as the drop-down list changes the colour accordingly, that is main thing.
Once again thank you