Your dropdown would need a lookup table with both the CELL format codes and their descriptions. Look up Excel's Help file for the CELL function to see what those are. I'm not sure how you'd plan to use the dropdown, though.

To return the codes for a positive match you could use:
=IF(AND(CELL("format",A1)=CELL("format",B1),CELL(" format",A1)=CELL("format",C1))=TRUE,CELL("format", A1),FALSE)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]