Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do i colourfill validated cells ?
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 . |
#2
|
|||
|
|||
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 . |
#3
|
|||
|
|||
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 . |
#4
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting empty cells within a range of cells | New Users to Excel | |||
Counting only active cells | Excel Discussion (Misc queries) | |||
Locate and delete specific cells | Excel Discussion (Misc queries) | |||
Help adding text values | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |