Hi ekr,

Do you want to do it manually?

You can use the FILTER feature of Excel.

Just set filters for the data range.

Then click on any column with a filter and use the FILTER BY COLOR option, and select No Fill.

Now select all visible rows. (F5; Special...; Visible cells only)

Press Delete.

NB: You could lose your headings, so make sure they are shaded as well.

You can do it by Macro as well, but a lot of people are wary of macros.

I hope this helps, please let me know!

Regards,

David

If this has been of assistance, please advise. A little thanks goes a long way.
- Please click on the *Add Reputation button at the bottom of helpful responses.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

When you reply please make it clear WHO you are responding to by mentioning their name.