'Data validation to Keep column I cell Empty if Condition Met in column J
Trying to add Data validation in column where first value before / >139 OR Last value after / >89 then Data Validation will strict the cell to add anything. It would be empty if condition met. I have tried but its not working your help will be appreciated.
=OR(IF(TRIM(LEFT(J3,FIND("/",J3)-1))>139),IF(RIGHT(J3,FIND("/",J3)-2)>89),"")
Solution 1:[1]
data validation uses same logic as conditional formatting...
=(REGEXEXTRACT(J3, "^\d+")*1>139)+(REGEXEXTRACT(J3, "\d+$")*1>89)
to Keep column I cell Empty if Condition Met in column J
=NOT((REGEXEXTRACT(J3, "^\d+")*1>139)+(REGEXEXTRACT(J3, "\d+$")*1>89))
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 |