How do I keep color and font btwn tabs in Excel 2003?
 

I want to create a status report in excel. Each item will have a tab with
specific information for that item. Certain portions of information from the
specific tab (CME) will go to a Summary tab using worksheet and cell
reference (=CME!B1).

How can I keep the color and font from the CME tab when it rolls up to the
summary?

Can I use colors on a drop down list?