if text not in cell then delete adjacent cell and loop until last cell with value

hi! please help, i cant figure out how to write this macro. i have attached a sample file for reference.

i want to make a macro such that
if the word "coupon" is NOT in the first cell with text starting in A2 THEN delete the text in the adjacent cell in coloumn C... so since A4 doesnt say coupon, the cell C4 should be blank
then i would like this to loop until the last cell with text in colomn A

also, i want to create the same macro but for the word "blu". IF a cell in colomn A, starting with A2, does NOT have the word "blu" THEN the adjacent cell in column d should be blank. i.e. a3 doesnt have blue, thus d3 should be blank

the sheet titled "origiinal" is that data and the sheet titled "final" is the result the macro should produce. please help any way possible!!!!! thank you in advance!!!

How big is your original file?
This would be a nice and slow way of getting results.

Please Login or Register  to view this content.

AutoFilter...

Please Login or Register  to view this content.

This works for the file attached, but it unfortunately doesn’t work with the original file... which I can upload. It deleted the entire Colombo in the original file instead of just the cell. Do you know how to fix this? Please and thank you!!

Originally Posted by jolivanes

How big is your original file?
This would be a nice and slow way of getting results.

Please Login or Register  to view this content.

Where did you get "Colombo" from.
It's no use attaching a non representative file.