Hi
_... I would put your requirement into two broad areas,
_A) One I can help with,
the other
_B) I cannot, at least not yet…

Part B) ( 4. 5. 6. ) is really a completely separate issue to Part A) ( 1. 2. 3. 7. )



_Part A) I am considering 1. 2. 3. And 7. here
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

And I wonder if the table should look like this, which is slightly different to what you gave…

_____ Workbook: Book1.xlsx ( Using Excel 2007 32 bit )
Row\Col AM AN AO AP AQ AR AS AT AU AV AW AX AY AZ BA BB
16 (Select Here)
16 Nuclear Family (Remark if any)
17 Joint Family (Remark if any)
18 Single-Parent Family (Select Reason)
19 Expired
20 Divorced
21 Break-Up
22 Abandonment
23 Enter Reason Manually
24 Uncategorised (Please Specify the Case)
Worksheet: Sheet1




I will move onto the next post, as I may need more space than the current post limit… _