Ensuring that all the cells are filled in

[mgrroyall]

Hi guys,

I'm trying to figure it out how to ensure that if some data is entered in A1 then the range B1 to E1 is to be filled in with data as well. If it is possible I would like to not allowed to save the file if the data is not entered in all required cells and display msg "please complete form before saving". The trick part is, I know it could be easily done with vba code but I wonder if it is possible to do it with a function?
Cheers
Mac

 

[Fluff]

Hi & welcome to MrExcel.
There is no way of doing that using formulae, you will need a macro.