Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
in a data validation list how do i color a choice?
i want the choices to be formated in different colors, or bold or italics, etc.
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
in a data validation list how do i color a choice?
Think your after Conditional Formatting. e.g if cell value = 3 you could change the format to Bold and Red Font. VBA Noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=560881 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
in a data validation list how do i color a choice?
Sam
You can't -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "Sam" wrote in message ... i want the choices to be formated in different colors, or bold or italics, etc. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
in a data validation list how do i color a choice?
you can, because i am working in a spredsheet that someone else created that
does. but how? "Nick Hodge" wrote: Sam You can't -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "Sam" wrote in message ... i want the choices to be formated in different colors, or bold or italics, etc. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
in a data validation list how do i color a choice?
Sam
As I pointed out I have maybe misunderstood that you wanted the items in the dropdown different colour etc. Maybe you should re-describe what you are looking to do and either myself or another person will let you know the answer -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "Sam" wrote in message ... you can, because i am working in a spredsheet that someone else created that does. but how? "Nick Hodge" wrote: Sam You can't -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "Sam" wrote in message ... i want the choices to be formated in different colors, or bold or italics, etc. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
in a data validation list how do i color a choice?
i see the misunderstanding. i wanted to change color of the item that was
selected and put in the cell, not the color of the list itself. i think i found the answer with conditional formating, it works well and is actually fairly inteligble without a manual. thanks for your help. "Nick Hodge" wrote: Sam As I pointed out I have maybe misunderstood that you wanted the items in the dropdown different colour etc. Maybe you should re-describe what you are looking to do and either myself or another person will let you know the answer -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "Sam" wrote in message ... you can, because i am working in a spredsheet that someone else created that does. but how? "Nick Hodge" wrote: Sam You can't -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "Sam" wrote in message ... i want the choices to be formated in different colors, or bold or italics, etc. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
in a data validation list how do i color a choice?
yes you can just select the cell you want to color then click format to the menu bar then select the conditional formatting:) -- xtrmhyper ------------------------------------------------------------------------ xtrmhyper's Profile: http://www.excelforum.com/member.php...o&userid=23851 View this thread: http://www.excelforum.com/showthread...hreadid=560881 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Choices from Data Validation List | Excel Discussion (Misc queries) | |||
Using a 'Select' (Data Validation) List? | Excel Worksheet Functions | |||
Data Validation using List (But needs unique list in drop down lis | New Users to Excel | |||
Data Validation list boxes | Excel Discussion (Misc queries) | |||
Using Validation List from Another Workbook with Dependent Data | Excel Worksheet Functions |