delete row if the font color is blue

i want to delete the entire row if the font color of cell is blue in column a

thanks in advance

Hi barkiny

See
http://www.cpearson.com/excel/colors.htm

And
http://www.xldynamic.com/source/xld.ColourCounter.html

The Beta version of EasyFilter can delete the rows for you
http://www.rondebruin.nl/easyfilter.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"barkiny" <barkiny.1zo3fo_1133954702.8264@excelforum-nospam.com> wrote in message
news:barkiny.1zo3fo_1133954702.8264@excelforum-nospam.com...
>
> i want to delete the entire row if the font color of cell is blue in
> column a
>
> thanks in advance
>
>
> --
> barkiny
> ------------------------------------------------------------------------
> barkiny's Profile: http://www.excelforum.com/member.php...o&userid=20397
> View this thread: http://www.excelforum.com/showthread...hreadid=491407
>

If activecell.Interior.ColorIndex = 5 Then
Activecell.Entirerow.Delete
End If

--

HTH

RP
(remove nothere from the email address if mailing direct)


"barkiny" <barkiny.1zo3fo_1133954702.8264@excelforum-nospam.com> wrote in
message news:barkiny.1zo3fo_1133954702.8264@excelforum-nospam.com...
>
> i want to delete the entire row if the font color of cell is blue in
> column a
>
> thanks in advance
>
>
> --
> barkiny
> ------------------------------------------------------------------------
> barkiny's Profile:
http://www.excelforum.com/member.php...o&userid=20397
> View this thread: http://www.excelforum.com/showthread...hreadid=491407
>