Home > OS >  Data validation to Keep column I cell Empty if Condition Met in column J
Data validation to Keep column I cell Empty if Condition Met in column J

Time:04-23

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),"")

enter image description here


to Keep column I cell Empty if Condition Met in column J

=NOT((REGEXEXTRACT(J3, "^\d ")*1>139) (REGEXEXTRACT(J3, "\d $")*1>89))

enter image description here

  • Related