Delete Rows That Have a Color Red in Cell

**ajocius** · 01-01-2009, 02:59 PM

Group,
Have a spreadsheet with several hundred rows. I'm running Windows XP and Excel 2007. Have data in columns A thru I. In column D I have Conditional Formatting that changes each cells color in D to either Green, Yellow or Red. How can VBA delete an entire row if the cell in column D is Red? When I run the macro, any row with red in its D column cell will be deleted.

**VBA Noob** · 01-01-2009, 03:18 PM

What condition triggers the change in colour as that would be easier to work with

VBA Noob

**ajocius** · 01-01-2009, 03:34 PM

If the value of a cell in col g equals the letters red, the first cell turns red. I guess I should have asked how to delete a row if another cell has the letters red. Does that make sense?

**VBA Noob** · 01-01-2009, 03:37 PM

Link has lots of examples

http://www.rondebruin.nl/delete.htm

think the quickest would be autofilter

http://www.rondebruin.nl/delete.htm#AutoFilter

Post back if you need help

VBA Noob

**Kenneth Hobson** · 01-01-2009, 04:32 PM

No cell just turns red. It turns by a Conditional Format or a Change event. The first requires some special macros. The 2nd method is easier.

For either method, it is easier to just add a column that results in a True or False value or some other value. One then deletes based on it. The formula is what governs turning the "cell red". Once you have that column added, one of Ron's methods will complete the project.

**royUK** · 01-02-2009, 04:26 AM

This will delete all rows where a cell in Column G starts with red.

Please Login or Register  to view this content.

Delete Rows That Have a Color Red in Cell

LinkBack

Thread Tools

Rate This Thread

Display

Delete Rows That Have a Color Red in Cell

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions