You can use the Fill Color button on the Formatting toolbar, to format
the cells.

Alan wrote:
How do I colour the cells to highlight each selection? red, green etc

"Debra Dalgleish" wrote:


Only the active cell can have the data validation arrow visible.
Perhaps you could colour the cells to highlight them, or add comments to
the cells to mark them.


coal_miner wrote:

Greetings. First off, let me thank anyone in advance for taking the time to
assist me. My question should be easy to answer. I have setup some drop
down lists in one of my worksheets. The button with the arrow that opens the
list hides itself after I click on another cell. How can I keep that button
always showing? Thanks again. Cheers.

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html