View Single Post
 
Old Yesterday, 12:08 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 958
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

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!
Reply With Quote