[Pindi-Islamabad:94481] 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

--
--
{{{{ Rawalpindi-Islamabad Friends}}}}
 
************************************************************************************
All members are expected to follow these Simple Rules
Abuse of any kind (to the Group, or it's Members) shall not be tolerated
SPAM, Advertisement, and Adult messages are NOT allowed
This is not a Love, Dating Forum so sending PM or Chat Inv will be considered as illegal Act. will be BANED Instantly.
************************************************************************************
You received this message because you are subscribed to the Google
Groups "Pindi-Islamabad Friends" group.
To post to this group, send email to Pindi-Islamabad@googlegroups.com
To unsubscribe from this group, send email to
Pindi-Islamabad+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Pindi-Islamabad?hl=en
 
---
You received this message because you are subscribed to the Google Groups "Pindi-Islamabad Friends" group.
To unsubscribe from this group and stop receiving emails from it, send an email to Pindi-Islamabad+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.