Hello All,

Cell A1 is having a dropdown list from 1 to 5.
Based on this data, I need to have a condition for cell A2.

If cell A1 is having data ‘1’, compulsory data entry is required for cell A2.
Cell A2 will have numbers or text and this will be entered manually.

If cell A1 is having some other data (2 to 5), this condition is not required. And entry in cell A2 is optional.

Please help me to implement this in Excel.

Regards,
Sudheesh