Hi Russell,

I have a worksheet that has a drop down list of Red, Green, Blue, and if you
pick the color from the list it turns the cell that color. It can be can
modified to return any color to the any cell of choice after the selection.

HTH
Regards,
Howard

"Russell Brown" <Russell wrote in message
...
VLOOKUP a number and fill a cell with a color that equals the number. i
require more than three colors so i can't use the 'ADD CONDITION' in
conditional formating
eg 1= red
2= green

if 1 is entered in a cell, then fill that cell in red