Multiple Conditional Formatting in excel 2003

[pchildress285]

Here is my problem. I have 5 list boxes and I want to have 4 of them to disappear and be unavailable for selection when I choose one of them but with excel 2003 I only have 3 conditional formatting options. Is there any solutions that are out there to help me accomplish my task. Thanks in Advance.

 

[venkat1926]

google search will give you some ideas
e.g.
http://chandoo.org/wp/2008/10/14/more-than-3-conditional-formats-in-excel/

 

[Yahya]

pchildress285
in Excel 2003 to do more than three conditional formatting, you need Code to do it.

 

[Marcelo Branco]

Here is my problem. I have 5 list boxes and I want to have 4 of them to disappear and be unavailable for selection when I choose one of them but with excel 2003 I only have 3 conditional formatting options. Is there any solutions that are out there to help me accomplish my task. Thanks in Advance.

Hi,

If i understood correctly, that is not an issue of Conditional Format.

I think you have to use the ListBox_Click event to set the Visible property of the other ListBox(es) to False.

M.