I used the solution from Conan Kelly for Thread "conditional formatting
from a list" posted a few above this one. By moving list to same page
did the trick. thanks Conan!!!

Johnny1r wrote:

Update: I have moved the name list to the same sheet as inpute names
(Sheet1) now CA4:CA304 Thanks John