duplicates in one column check another for duplicates

what would the formal be for excel to check column A for duplicates and if found in column  check column D for duplicates?