Description:
I am using drop down menu list in Excel to fill data. example, I have
define a range having 2 values "yes" or "no"

Problem:
I have formatted the list data in different colors but this function
does not pass that formatting to the destination

for more understanding, please see the attachment


+-------------------------------------------------------------------+
|Filename: excel.JPG |
|Download: http://www.excelforum.com/attachment.php?postid=4261 |
+-------------------------------------------------------------------+

--
elegantpartner
------------------------------------------------------------------------
elegantpartner's Profile: http://www.excelforum.com/member.php...o&userid=30257
View this thread: http://www.excelforum.com/showthread...hreadid=504194

I don't think you can pass the formatting but as you are only using 2
values it would be quite easy to use conditional formatting in the
destination cells to achieve what you want.


--
millsy
------------------------------------------------------------------------
millsy's Profile: http://www.excelforum.com/member.php...fo&userid=5122
View this thread: http://www.excelforum.com/showthread...hreadid=504194

That was just an example, my required list has around 10 options


--
elegantpartner
------------------------------------------------------------------------
elegantpartner's Profile: http://www.excelforum.com/member.php...o&userid=30257
View this thread: http://www.excelforum.com/showthread...hreadid=504194