Hi,

I have an interesting question, I want to force a user to select from a drop down list based on a calculated field... Im doing a cash reconcilation, so If column B has a discrepancy the user will have to select from a drop down list.

I have a drop down list in column c that gives a user a range of reasons? Column b is a calculated field which is a result of other colums.. put simply it?s a sum of ?

Now my question is ? if there is ANY value in column b? the user MUST Choose a reason from the Drop down list in column c? if they don?t then excel Must prompt them to do so?. What is the best way to solve this problem?? i tried data validation.. but it doesnt work... I would appreciates anyones professional expertise.