I want to display a drop-down validation list for a target cell only if the
vlaue in another cell meets or exceeds a numerical threshold. If the
threshold is not met, I want to force the target cell to remain blank.


Cell A contents ----- Cell B contents
< 100 must be blank
= 100 may only be "red" or "green" or "blue"

Using MS Office Excel 2003