I'm using Excel for an education-related room booking system.
Statistics are produced from the data and I have reasonably effective field
validation rules in place to ensure that data quality is good when it is
entered.
What I can't seem to do 'easily' is ensure that all relevant fields are
completed fgor each booking - I need to make completion of several fields
compulsory if any of them is entered.
Any help would be gratefully received.
Thanks,
Martin