Moving data to other columns from conditional formatting

I have two groups of data that I have conditional formatting applied to show the duplicates. I am attaching an example, but I would like to pull the approved curricula that is not highlighted in green to column D. I would like the training log data (column b) to pull to the extra column (column E). And lastly from the date column, I would like to pull all of the STOP trainings to the stop column (column F).

Any help would greatly be appreciated!!