Name your range of allowed values on the "delta" sheet (eg "LIST")

Used conditional formatting on the data entry range
Formula: =AND(A1<"",ISERROR(MATCH(A1,LIST,0)))
Set the "error" format however you want.

Tim


"project manager" <project wrote in
message ...
I am trying to make a macro which will conditionally format a cell in range
c5:c27 in worksheet alpha, when the text entered does not match a text
entered in a much longer list (A1:A947) in a different worksheet (delta).
I
dont think i can use a data validation because i need the users to be able
to
enter a text/value but it just flag up to me that its wrong. the format
when
its wrong/ different from the list is text colour black, bold italic, cell
colour red.

any help would be awesome.