VALIDATION
is it possible to use an if statement in data validation? i use validation to
select a list for column J based on data in column A, but if a specific value in column F appears the list for column J must be different ( but will still contain some of the values if the specific value in column F does not appear) |
VALIDATION
See:
http://www.contextures.com/xlDataVal02.html -- Gary's Student gsnu200702 "gbc65" wrote: is it possible to use an if statement in data validation? i use validation to select a list for column J based on data in column A, but if a specific value in column F appears the list for column J must be different ( but will still contain some of the values if the specific value in column F does not appear) |
All times are GMT +1. The time now is 07:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com