Hello,
I'm trying to set up one cell to be required to be 12 digits long if the cell to the left is equal to "S". How do I accomplish this using data validation. I tried this formula and thought it was working but it it was restricting the value in E7 no matter what value was in D7: =IF(D7="S", LEN(E7)=12). The point is to disallow incorrect ticket numbers in column E when column D designates "S" as the hauler. Thanks!