Macro - Delete or Hide Based On Conditional Format Font Color

[ValiMandy]

Hello,

I would like a macro that runs when the sheet is activated. I would like it to delete any row that contain white font, however the font will be white because of conditional formatting. Also, I can make that work otherwise if we could complicate it more and have it only look in Columns B:J that would be even better.

Thanks, and hopefully this is possible. I'm not so great with Macros.

Mandy

 

[abhi1687]

put below in worksheet code module:

Private Sub Worksheet_Activate()

Dim cel As Range

With Me
    For Each cel In .Range("B1:J" & .UsedRange.Rows.Count)
        If cel.DisplayFormat.Font.Color = vbWhite Then cel.EntireRow.Delete
    Next
End With

End Sub

 

[ValiMandy]

Thank you very much!!