G
Guest
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.
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.