Delete Rows that pass Conditional Formatting

Hi all,

I have a large table (Around 4500 rows at present) which has conditional formatting set so if there is a client ID match it will highlight the entire row red. I then delete these rows.

Problem I have is that there are hundreds of red rows and I dont want to delete them manually as this spreadsheet is going to be used in 50 different sites.

Can anyone provide a VBA script that will delete this for me please?

Many Thanks

James