How to make multiple cells mandatory based on criteria in excel
All. I'm an intermediate excel user that needs your help, I would like to create a condition to have a certain cell become required if another cells have information in it.
If there is any value entered in cell E12, then its mandatory to update C12,F12, G12, H12,I12,J12,K12,L12,M12.
this should be same for E13 to E25.
Kindly help me in solving this.
Here's a start on what I think your trying to achieve.
Put this code in the worksheet module you are working with. Not a normal module.
Please Login or Register to view this content.
Last edited by ptmuldoon; 08-16-2017 at 10:36 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks