Drop-Down Menu with Multiple Conditions

[Anshu]

Hello!

I've a sheet with only 2 two cell but with multiple conditions.

These are the conditions:
1. If the cell "J19" is empty, it show "(Select)" in fade font.
2. Cell "J19" has 4 Drop-Down Menu. When the first menu "Nuclear Family", or the 2nd menu "Joint Family" is selected, Cell "R19" show "(Remarks if any)" in fade font.
3. If the 3rd menu "Single-Parent Family" is selected, Cell "R19" show "(Select Reason)" in fade font.
4. On clicking this cell "R19" a drop down menu appear with 5 option - "Expired" "Divorced" "Break-Up" "Abandonment" "Enter Reason Manually"
5. On selecting an item, it apper in normal color and format
6. On selecting "Enter Reason Manually" from this drop-down, the cell "R19" becomes empty, so that the reason can be entered manually.
7. If the 4th menu "Uncategorised" is selected, Cell "R19" show "(Please Specify the Case)" in fade font.

Annotation 2020-08-27 182859.jpg


All these conditions are well explained in the excel file attached below. Please have a look to understand clearly my points.


Thanks for looking my post!!