populate cell if condition is met

Try posting a copy of your workbook instead of a text file containing partial code. Remove any sensitive data and replace it with fake values that mimic your real data. We also don't need 10,000 example rows, but enough to replicate the process.