I have a table in a worksheet. The data validation drop-down list in column I (column name: Result) is dependent on values entered in column E (column name: Test). The data validation formula in column I is this: =IF($C2="QualTex Validation",ValidationResult,IF(OR(ISNUMBER(SEARCH("B&F",$E2)),OR($E2="Plateletphereses, 4-day",$E2="Plateletphereses, 5-day",$E2="Plateletphereses, 7-day")),STBTCResult,Result)).

I will add a new value to column E: Residual Moisture.

I need column I to keep the data validation formula listed above UNLESS column E states "Residual Moisture". If it states "Residual Moisture", then column I will allow free text. (It would allow numerical values of a percent, exempli gratia 0.36%.

Is there a simple VBA for this?