Delete entire row based on cell color
This deletes row 5 if the font in column 1 (A) is red:
Sub test()
If Columns(1).Font.ColorIndex = 3 Then Rows(5).Delete
End Sub
HTH
-John Coleman
CMcK wrote:
Hello,
Could someone show me how to develop a macro that would delete an entire row
depending on the font color (ie: red) of text in column A.
Many thanks.
CMcK
|