Delete Rows Based On Color

I have cells that are conditionally formated based on certain criteria. I was hoping someone knew of a macro I could use in order to delete all rows that were conditionally formatted to have a black background? Any help would be greatly appreciated!!!!

Sincerely,
Tom

Hi

So far as I am aware it is not a simple matter to test for a conditional format in VBA, here is a link that details how it can be achieved http://www.cpearson.com/excel/CFColors.htm.

If the conditional format conditions are constant it would probably be simpler to test for the condition, rather than the color, and then execute the necessary action.

Regards

Jeff