View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Adi Adi is offline
external usenet poster
 
Posts: 3
Default 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