Cell A1 can have any value.
Cell B1 has data validation in place, and thus can only have four values.
If I type "run" in cell A1, I want the value in cell B1 to change from "Slow" to "Fast."
The kicker is this: Cell B1 cannot be a formula like =IF(A1="run","fast","slow"). It needs to be the text string "fast" or "slow" or any of the other values in its data validation table.
I've seen a spreadsheet that populated values based on another cell's entry without a formula, but the spreadsheet has a password on it and I cannot figure out how it was done (see attachment).
I'm curious if this can be done with a macro... I've successfully written a macro that will change the value in cell B1, but is there a way to cause a value to run only if the value in cell A1 is changed to a specific text value?