If you chose to ignore it then the value stays in the cell

That depends on what type of error alert you're using. There are 3 different
levels: Stop, Warning and Info. If you use the Stop level you can't manually
enter a non-matching value in the cell.

You could conditional formatting to highlight entries that are "not
allowed".

--
Biff
Microsoft Excel MVP


"Peter" wrote in message
...
Hi,

In the data validation function using list, if you manually insert a value
that doesn't exist within this list then you get an error. If you chose to
ignore it then the value stays in the cell even though it doesn't exist
from
the available list of entries.

My question is, how do I get Excel to inform me which cells within the
workbook have such a case? Is there a way to run something to re-check all
relevant cells that are using data validation and whether the value is an
valid entry.

Hope my question makes sense!
Thanks in advance
Peter