Take look at conditional formatting.

Look up 'Highlight cells that meet specific conditions' in the Answer
wizard in help


--
HTH

Bob Phillips

"Bushy" wrote in message
...
as above, i have created a workbook with cells that have dropdown menus,
now
need to colourfill validation cells so when selected carry colour fill and
text over to worksheet .