select-delete highlighted cells after conditional formatting

**aiolosply** · 07-17-2012, 12:48 PM

after highlighting the cells based on criteria explained here: http://www.excelforum.com/excel-gene...lc-filled.html

i need to delete or select the highlighted cells
how can I accomplish that?

I tried using a macro without success...any feedback?

Sub DELETEDHIGHLIGHTED()
'
' DELETEDHIGHLIGHTED Macro
'
'
For Each Cell In Range("K1:K5172")
If Cell.Interior.ColorIndex = 1 Then 'highlight colour is black
Cell.Offset(, -1) = "X"
End If
Next Cell
End Sub

**aiolosply** · 07-17-2012, 01:13 PM

what i need is to integrate this

=IF(AND(A2="";B2="";D3=""); 1)

in a macro that will result to the deletion or selection of the cells meeting the criteria in a specified column range

**aiolosply** · 07-18-2012, 04:41 AM

cant anyone help out in this one? the macro needs to apply a delete function on highlighted or be integrated with the conditions above

**aiolosply** · 07-18-2012, 07:25 AM

what if I transfer the file to a pc with an Excel 2010 and select by highlighted colour?Is that possible, will it keep the formatting I have made in excel 2003