I have a named list called 'NS' in sheet B.
On sheet C, I would like to use this list to validate column C and use
conditional formating to change the background to red for items not found in
the list NS. Can anyone point me in the right direction? Is a formula in
conditional formatting the way to approach this?

BTW - is there a way to remove blanks from a named list?
Thank you.

See previous post.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Ron" wrote in message
...
I have a named list called 'NS' in sheet B.
On sheet C, I would like to use this list to validate column C and use
conditional formating to change the background to red for items not found
in
the list NS. Can anyone point me in the right direction? Is a formula in
conditional formatting the way to approach this?

BTW - is there a way to remove blanks from a named list?
Thank you.