Excel 2003 - conditional formatting and lists
 

I have created a list called 'FullName' which will be added to with a
macro.

When using this list in a cell using Conditional formatting is it
possible to have the dropdown list sorted in alpha order without
having to put the original list through a manual sort or macro sort
beforehand?

Any advice would be appreciated

Thanks

BJ