I'm always frustrated when I attempt to do what seems like a simple macro, and cannot accomplish it. Right now is one of those times.
After running a VBA based sort, I need my worksheet to highlight the rows whose cells in column Q match todays date (displayed as MM/DD).
Here's my code, which produces...nothing:
Can someone kindly steer me in the right direction?
PS - conditional formatting is not the right solution for this application.
TIA
After running a VBA based sort, I need my worksheet to highlight the rows whose cells in column Q match todays date (displayed as MM/DD).
Here's my code, which produces...nothing:
Code:
Dim cell As Range
lr = Cells(ActiveSheet.Rows.Count, 23).End(xlUp).Row
For Each cell In Range("Q2:Q" & lr)
If cell.Value = Date Then
cell.EntireRow.Interior.ColorIndex = 6
Else
cell.EntireRow.Interior.ColorIndex = xlNone
End If
Next
Can someone kindly steer me in the right direction?
PS - conditional formatting is not the right solution for this application.
TIA