Can I format a cell in excel based on a list of about 20 items?

I'd like to have a list of about 20 items, and when an item is chose from
that list, i'd like for excel to have specific formatting for each item.
I've tried conditonal formatting, but it seems like only 3 conditions can be
met.
Is there any way to do this?

The addin at this link may help you:
http://www.xldynamic.com/source/xld.....Download.html

--
tj


"arkansooner" wrote:

> I'd like to have a list of about 20 items, and when an item is chose from
> that list, i'd like for excel to have specific formatting for each item.
> I've tried conditonal formatting, but it seems like only 3 conditions can be
> met.
> Is there any way to do this?