Need a macro to delete row based on conditionally formatted cell

Hi,

I would like to seek for your help. I came across a code that deletes a row if it is not highlighted.

Please Login or Register  to view this content.

This works if the cells are manually highlighted, but I need it to work for a conditionally highlighted cell.

I know it was already talked about here: http://www.excelforum.com/excel-prog...ghlighted.html but I couldn't make it work.

Thank you in advance!

Originally Posted by AndyLitch

Rather than use the colour of the cell to determine whether to delete - use the criteria that sets the colour i.e. the criteria for the conditional format

Hi Andy, thanks for your reply. I appreciate it. While that's possible, the criteria for my conditionally formatted cell is more complicated since it uses a formula.