Originally Posted by murugavelmsc (Post 1609664)

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.

In the data validation i use the following custom foruma
=IF(C2="YES",AND(COUNTA(A2,B2,C2)=3,D2=DATE(2013 ,1,1),D2<=DATE(2014,12,31)),"NO")




pLEASE HELP ME

THanks,
Murugavel S

Originally Posted by shanermuls (Post 1609665)

Example attached - changed "NO" to "NA"

where is the date for this? You are checking column D for a date in 2013 or 2014 - the date is not in your example.

also why are you checkin if count(a2, b2, c2) =3?

Originally Posted by murugavelmsc (Post 1609668)

HI,

In column C2 has dropdowlist as "Yes" or "No".
when i am selecting "No" in the cell C2, the D2 cell populates the value "Na". But I am selecting "Yes" in column C2, it allows the date conditon between 2013 - 2014 and the check the values A2 and B2 are enetered.


Hope you are clear now.

Thanks,
Murugavel S