Aug 13 2019 09:24 PM
Hi,there.I need to set a data validation in a cell so it shows a specified text automatically in condition 1, and shows a drop down list in condition 2,is it possible?
I've attached the data for example, many thanks for any advice.
Aug 13 2019 11:26 PM
Solution
Hi,
Initially, you need this formula in the Status column:
=IF(A2>$F$1,"not started yet",IF(B2<$F$1,"finished","SelectStatus"))
If the two conditions failed, the formula will show (SelectStatus) which will be the source reference of the drop-down list in the data validation.
You will notice that when the cell contains (SelectStatus), the drop-down list will be available.
One restriction to this solution is that when you select the status from the drop-down list, you can't select it again until you apply the formula on the range again or type (SelectStatus) in the cell manually!
Please find that in the attached file.
Aug 15 2019 02:09 AM
@Haytham Amairah Thank you so much!This really does much help to my work.
Aug 13 2019 11:26 PM
Solution
Hi,
Initially, you need this formula in the Status column:
=IF(A2>$F$1,"not started yet",IF(B2<$F$1,"finished","SelectStatus"))
If the two conditions failed, the formula will show (SelectStatus) which will be the source reference of the drop-down list in the data validation.
You will notice that when the cell contains (SelectStatus), the drop-down list will be available.
One restriction to this solution is that when you select the status from the drop-down list, you can't select it again until you apply the formula on the range again or type (SelectStatus) in the cell manually!
Please find that in the attached file.