You can color the cell after a value has been selected using Conditional
Formatting.

Not before.


Gord Dibben MS Excel MVP

On Wed, 25 Mar 2009 17:15:01 -0700, Topman
wrote:

How do i colour code the values in my dropdown list ?