Hello everybody,
I have following problem. Can I activate any cell based on option selected.
For example
in cell A1 there is dropdown list and user is required to select one option out of two say Purchase Price, Notional Value.
I want that user will enter date of purchase in cell B1 only if option selected is Purchase Price. If option selected is Notional Value , user need not enter any date. By dafault date 1st April, 1981 should get entered in cell b1.
Can anybody tell me how to do this.
Thanks
Bookmarks