Excel 2003 - conditional formatting and lists

B

BJ&theBear

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Hold conditional formatting when sorting filtered data 1
Conditional Formatting in Excel 2003 2
sorting spreadsheet with conditional formatting 1
Conditional Formatting with VBA 4
Copy Conditional Formats on a List 2
Color Conditional Formating 2
Copying conditional formatting 0

Top