Data Validation List

HI Experts,

A B C D
101 ABC NO

In D column i have a data validation i'e if c1="No", "NA", count(A1, B1)>=2 and D2>=DATE(2013,1,1),D2<=DATE(2014,12,31)

when i am selecting C1 as "No", not automatically populates "NA" in column.

Attached file is for your reference.

pLEASE HELP ME

THanks,
Murugavel S

Cross posting here in Excel Forum

(Not able to add the link-I need 5 posts for this!?)

I can though http://www.excelforum.com/excel-programming-vba-macros/901928-data-validation-list.html

Thanks BOB!