compare code in two sheets

Please Login or Register  to view this content.

Above is my attempt to accomplish this when the user clicks compare amplicons:

STEP 1: Match column D in Template with column D in Source if it is highlighted Red.
STEP 2: If there is a match then to the Low Coverage worksheet all the information in columns A,B,C,D,E,F,G,H,I,J
STEP 3: Match column D in Template with column D in Source AND If in Column J there is a Y then column J in Low Coverage is Pink, if in Column J there is a N then column J in Low Coverage is Y Green, if in Column J is “” then column J in Low Coverage is Yellow with a ? in it

I'm sure it is not right, any assistance would be appreciated. I attached the spreadsheet as well. Thank you.