I am using the Data -- Validation feature in Excel. Each cell using this
function references a specific set of cells for the desired list of
selections for each user to input. Occaisionally the user will copy and paste
incorrect data into the cell and it will avoid the error alert that I have
set up for these cells. How can I make the error alert appear (or prevent the
user from entering this incorrect information) even when they copy and paste
the data?

Thank you,

I have a list of acceptable values G1:G10
Cell A1 has Data Validation pointing at this list
Cell A1 has Format|Conditional Formatting set with Formula IS
=ISNA(VLOOKUP(A1,G1:G10,1,FALSE)) and pattern is set to red
If I copy a value into A1 and that value is not in my last then A1 displays
red
Any use?
I expect a VBA solution will be offered soon but this list seems a little
slack today - too much merry making?
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"tjh" wrote in message
...
I am using the Data -- Validation feature in Excel. Each cell using this
function references a specific set of cells for the desired list of
selections for each user to input. Occaisionally the user will copy and
paste
incorrect data into the cell and it will avoid the error alert that I have
set up for these cells. How can I make the error alert appear (or prevent
the
user from entering this incorrect information) even when they copy and
paste
the data?

Thank you,