Change color of Drop Down List (Validation box)

K

Kaylen

I am creating a form in which there is a column with drop down list where
users select answers. I do not want the answers to be distinguished from the
rest of the form in any color or format after being selected. How do I make
the drop down list to stand out in color or any format in the form so users
know they need to select answers for that column. But after all answers
selected from drop down, the answers columns look the same as the rest of the
sheet? Any help is appreciated. Thank you.
 
R

Roger Govier

Hi Kaylen

As well as applying DV, also select the same range and apply Conditional
Formatting.
Assuming that data is in column A,
Format>Conditional Formatting>Formula is> =$A1="" >Format>Fill colour>Choose
whatever colour you wish.
 

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

Excel Excel: How do I put a formula in a drop down list 11
How do you change the color of the drop down button on filtering? 1
Data Validation List (conditional) 2
Formatted cell column in drop down list 1
Drop Down List 2
Data Validation and drop-down list using IF, AND and what else? 8
produce list automatically from choice of drop down list 1
Combo Box 1

Top