Hello,

I have a worksheet that imports a table from access and have conditional fomatting that Identifies whether items are late are not. If it is late to department1, it turns the cell in AC red. If it is late to department1, it turns the cell red in AD. I would like the code to find the last row in the workbook, which there will always be something in column D...so you could base the last row off of that column. Anyways, I want each row that doesnt have coloring in columns AC and AD to be deleted from the workbook. I only want Rows that have columns that are red in AC and AD, or both at the same time. Any help would be appreciated.

Thanks,
John