ListBoxes - Different Elements, different colours.
 

Greetings I'm just wondering if anyone can help me out with an issue on List
Boxes.

Here is an example

Billy
Timmy
Bob
Shane

These are 4 different elements within the List Box, If Timmy has recieved a
low mark I want the text or simply the background of that element only, to
turn an orange. Is customisation of the elements possible like this?

Thank you in advance.

ListBoxes - Different Elements, different colours.
 

Take a look at this. Does this do what you want?
http://www.contextures.com/xlCondFormat01.html

As far as I know, you can't apply CF to a ListBox, but someone may be able
to offer you VBA code that would actually do that.

Anyway, hope that helps.

Regards,
Ryan--
--
RyGuy


"NateBuckley" wrote:

Greetings I'm just wondering if anyone can help me out with an issue on List
Boxes.

Here is an example

Billy
Timmy
Bob
Shane

These are 4 different elements within the List Box, If Timmy has recieved a
low mark I want the text or simply the background of that element only, to
turn an orange. Is customisation of the elements possible like this?

Thank you in advance.

ListBoxes - Different Elements, different colours.
 

There's nothing built in but Andy Pope shows a way to do it, clever stuff!

http://www.andypope.info/vba/colourdropdown.htm

Regards,
Peter T

"NateBuckley" wrote in message
...
Greetings I'm just wondering if anyone can help me out with an issue on
List
Boxes.

Here is an example

Billy
Timmy
Bob
Shane

These are 4 different elements within the List Box, If Timmy has recieved
a
low mark I want the text or simply the background of that element only, to
turn an orange. Is customisation of the elements possible like this?

Thank you in advance.