View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
relo rob[_2_] relo rob[_2_] is offline
external usenet poster
 
Posts: 9
Default delete all cells with color

I have used conditional formatting with a formula is statement to highlights
cells in a column of about 5800 rows. Now that certain cells are highlighted
with one color how can I delete just them cells so I can work with the data
that is left?