In 2003 you can specify the Format color to look for under
Edit>Find>Options>Format>Format.

Select the color from the Patterns dialog and Find All.

In the found dialog box the first cell will be highlighted.  Hold SHIFT key and
scroll down to bottom of dialog box and select last cell.

Edit>Delete will get rid of the red rows.

If earlier version you would have to use VBA

See Chip Pearson's site for cellcolorindex function.

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

Gord Dibben  MS Excel MVP