Set conditional formatting formula for cell A5 as =ISNA(MATCH(A5;$J$1:$J$19;0))
But is there a reason you don't use data validation list with source as $J$1:$J$19 for cell A5 instead? User simply can't enter anything except values in range $J$1:$J$19!
|