1) all text is "greater" than all numbers, that's an Excel thing. So "a" is greater the 1,000,000. Trust me.
2) you defined a "string" variable in your macro and then put the date from your sheet into it. That converted that date into a STRING which is text, and ALL text is greater than all numbers. (see #1)
3) having said all that, there's no reason to do this with a macro when you can get this effect in realtime on column L by using conditional formatting.
- Highlight column L
- Apply a new conditional formatting rule with the formula:
=$L1 > Date_Lookup
Bookmarks