Data Validation error message

P

Peggy

Hi,

I have set up a data validation to include a drop down box of a list of yes
or no on my question. I have also set up a conditional format to color the
box in if the answer is no. however I'm having trouble getting the error
message box to flag up if they select no. I thought I would take no out of
the drop down box as one of the options, however I would really like to leave
'no' in as a choice and have the error message flag up and have the box
coloured red.

I would also like to have a formula set up whereby if say cell C1 is empty
then to take out the information in cell A1.

Can you help???

Kind regards,
Peggy
 

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

Testing a cell value for a specific weekday. 3
how do I get cells to automaticly change colour on data input? 2
validation data 1
Remove blank cells from data validation drop down box 3
Data Validation List Names 2
Drop down fill box does not appear when cell clicked. 1
How do I create a drop down box within a drop down box? 1
dates from a data validation 3

Top