View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default Delete row by color of font

How did the font become red... manually colored or via a Conditional
Format?

--
Rick (MVP - Excel)


"Lee" wrote in message
...
I have 80 rows of data and and one of the columns contains the serial
number
of the row (i.e. 1 through 80). The serial number font is normally black
but
if the font is red, I need to find the row number to delete that row.
Does
anyone know how to do that? It would be nice to do it without looping to
save time.
Thanks in advance,