Hi Shrini,
I think without macro it is not possible to do as formulas can not control objects and a workbook is an object. But you can do one thing by using conditional formatting you can intimate user to fill the cell B1 if there is any value into cell A1. Regards Prince. On Monday, November 19, 2012 11:12:23 AM UTC+5:30, shrini wrote: > > Dear All > Please help me for following problem. > I want to make a Cell "B1" mandatory based on Cell "A1". > Means if there is any value in Cell "A1" then "Cell "B1" can not empty > there should be some value . > Eg. > In Cell "A1" I will Enter Name of te person then Age should compulsary > enter in cell "B1" > System should not allow me to close the file without entering the age in > Cell "B1" > is it possible without macro? > > Thanks in advance > > > > -- > Shrini > -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
