Data validation
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. |
Data validation
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. |
All times are GMT +1. The time now is 11:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com