I have a list created in sheet 'B' named 'NS'.
I need to validate data in sheet 'C' in column C based on said named list.
I would like to use conditional formating to 'flag' data (red background) on
Sheet C, column C that does not exist in list 'NS'. I need help getting
started on this.

Also, I have inserted list "NS" as a pick-list for other purposes. Is there
a way to remove blanks from the list?

See http://www.contextures.com/xlDataVal01.html and
http://www.contextures.com/xlCondFormat01.html

--

HTH

Bob Phillips

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

"Ron" wrote in message
...
I have a list created in sheet 'B' named 'NS'.
I need to validate data in sheet 'C' in column C based on said named
list.
I would like to use conditional formating to 'flag' data (red background)
on
Sheet C, column C that does not exist in list 'NS'. I need help getting
started on this.

Also, I have inserted list "NS" as a pick-list for other purposes. Is
there
a way to remove blanks from the list?