I have used a 3 conditional formats for other things. With vba, I would like
to have a cell fill be red and the font black if the cell equals a date in
cell K7. The range of cells for this possible format is D12:J81

I found some code on the net and tried to modify it to get it to do what I
want ...I made into a disaster.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
With Range("D12:J81")
If Application.Cells = Today() Then

..Interior.ColorIndex = 3
Else
..Interior.ColorIndex = 0

End If
End With
End Sub

Thanks for any help

ADK