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.