[www.keralites.net] Excel Tip: Enable Data Entry in a Cell only if a Dependent Cell is Filled

 

You would have seen this in various online forms, where you must fill a cell before moving to the other. This construct ensures that you do not miss out on filling some of the data. Something as shown below

A colleague wanted a similar construct in Excel, and the only thing that came to my mind was Data Validation.

Here is how you can create this in Excel

1. Select cell A2
2. Go To Data –> Data Tools –> Data Validation
3. In the Settings tab go to the Allow drop down and select Custom
4. In the Formula field, type =NOT(ISBLANK($A$1))
5. Ensure that the Ignore blank is Unchecked
6. Click Ok

Now when you enter something in cell A2, and if A1 is empty, an error will be displayed.

source: TrumpExcel

---

www.keralites.net

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 31

Visit Your Group

KERALITES - A moderated eGroup exclusively for Keralites...

To subscribe send a mail to Keralites-subscribe@yahoogroups.com.
Send your posts to Keralites@yahoogroups.com.
Send your suggestions to Keralites-owner@yahoogroups.com.

To unsubscribe send a mail to Keralites-unsubscribe@yahoogroups.com.

Homepage: http://www.keralites.net

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___