font color as condition in if statement

hello all,

i have some difficulties with vba coding

in the master sheet i have 2 columns (prio and descriptions).
if there's a 1 in the prio column, row is copied to sheet 1. the color of the text turns blue after copying.

how do i exclude it from being copied again as i run the macro for new data to be copied?

thx

excel sheet in attachmentKopie van test.xlsm

Try this:

Please Login or Register  to view this content.

Thank you soo much