Forcing users to enter value based on criteria
Hi Everyone and Happy New Year,
I have created a simple worksheet so users can record the time they spend on
certain task. However I need help with the following:
If B5 is not blank then the user should be prompted to select a value from C5.
What formula/function should I use to make this work?
Many thanks,
Andy
|