how do i colourfill validated cells ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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,
 
You should be able to get 3 conditions, which gives 4 colours if you use a
default.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Validation/Conditional Formating 3
Data Validation List: Text Size Query 2
Data Validation Error 1
2007 data validation not working 1
Data Validation - Cell Colour 3
Excel Count If Formula Question 1
Data validation 3
Question about conditional formatting of zeros in Excel 0

Back
Top