Color entire row depending on value in a column

Greetings! I'm hoping someone can help me with this logic for my macro.

I have expiration dates located in Column N and need to color the entire row depending on what the expiration date is.

Expiration date is >90 days from today = Green
Expiration date is <=90 days from today =Yellow

The biggest confusion for me is the filtering criteria- how can I filter for greater than 90 days from today?

You can use (e.g.): $N2>Today()+90

It sounds like conditional formatting might be a better fit than a macro, though.

Thanks, Cantosh but I need to use a macro for this piece.

Maybe:

Please Login or Register  to view this content.

Thanks, John!! Your code didn't completely work, but it gave me the guidance I needed. Below code is working perfectly, for anyone interested.

Thanks again!

Please Login or Register  to view this content.

You're welcome. Glad I could help.

So I tried the macro below on a new data set and it looks like if the filter does not include data the header row is colored.

Please see my attachment. Any help/guidance would be greatly appreciated. First tab shows what the data is like post-macro and second tab is the ideal outcome. I believe it may have something to do with the portion End(3)?

Please Login or Register  to view this content.

Try:

Please Login or Register  to view this content.

Thanks, but that didn't work for me. I got the same result as the initial macro with the header row highlighted.

For anyone interested, here's the piece that was missing: I forgot to include If condition. If there was nothing filtered to move to the next statement.