Make a cell mandatory based on another cell value

Last Edited By Krjb Donovan
Last Updated: Mar 05, 2014 09:47 PM GMT

Question

I'm a basicuser and i need your help for my below requirement .

If a value is entered in cell D2, then cells D3 and D4 should be made mandatory to fill. If cells D3 and D4 are not filled the user should not be allowed to save the file.If nothing is entered in cell D2 then it is fine have cells D3 and D4 blank. I need similar conditions for the cells range D2 to W2.(Ex.: Value entered in cell E2, then E3 and E4 should be made mandatory)

Can you please help me?

Answer

It can be done usingVBA Macro. However, users could still turn off macros and bypass the setup. Natively in Excel, what you described cannot be done and even with VBA, it is not perfectly foolproof.

Advertisement

©2021 eLuminary LLC. All rights reserved.