Delete row based on red color font

hi expert...

i have problem to delete row based on red color font (without bold), for example :

input :
title1 george
title3 mike
title4 zidan

output :
title4 zidan

how do figure it out??

thanks in advance....

Hi Jhon, would like some more information here to be sure how to proceed. For instance, is "title1 george" the value of two cells or only one?

Cheers

thanks berlan, for the cell contains red color font, the row is deleted...

sorry i am missed it..should be :
title1 george
title3 mike

Hi again, thanks for the added info, try this (see attached):

Please Login or Register  to view this content.

Cheers, berlan

thanks Berlan. It's really working good....