Moving data to other columns from conditional formatting

[hurky12]

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!!

[sandy666]

[ deleted by me ]

[hurky12]

I changed my title - thanks!

[JeteMc]

Hello Hurky12 and Welcome to Excel Forum.
Thank you for changing the title.
If I understand correctly then the following should do what you want.
This proposed solution employs two helper columns which could be moved/hidden for aesthetic purposes.
The formula that populates the first helper column is: =ISERROR(MATCH(A7,B$7:B$104,0))
The formula that populates the second helper column is: =ISERROR(MATCH(B7,A$7:A$100,0))
The array entered formula* that populates column D is: =IFERROR(INDEX(A$7:A$100,SMALL(IF(G$7:G$100=TRUE,ROW($7:$100)-6),ROW(1:1))),"")
The array entered formula* that populates column E is: =IFERROR(INDEX(B$7:B$104,SMALL(IF(H$7:H$104=TRUE,ROW($7:$104)-6),ROW(1:1))),"")
The array entered formula* that populates column G is: =IFERROR(INDEX(B$7:B$104,SMALL(IF(C$7:C$104="Stop",ROW($7:$104)-6),ROW(1:1))),"")
*Array entered formulas are confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Let us know if you have any questions.

[hurky12]

This is exactly what I needed Thank you so much for your help on this!!!

[JeteMc]

You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools link above your first post. I hope that you have a blessed day.