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 .

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 .

Thanks Bob, this sort of helped but could only get 1 cell to format with one
colour, no others would format , will keep trying anyway,

"Bob Phillips" wrote:

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 .

You should be able to get 3 conditions, which gives 4 colours if you use a
default.

--
HTH

Bob Phillips

"Bushy" wrote in message
...
Thanks Bob, this sort of helped but could only get 1 cell to format with
one
colour, no others would format , will keep trying anyway,

"Bob Phillips" wrote:

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 .