Code to look at 2 columns, one finding like value and the other evaluating Dates

I would like a Code to Ask the user for a "Date Span" then look at column "A" to find the Like PROD ID's, then look at column "P" to see if the PO Write Dates fall into the requested Date Span. This case in yellow would be a Date Span of 1 Day.


Attachment 207559

This works perfect for what I asked for. Thank you!
Could this be changed to have it highlight any span say Less Than the inputted number of days, say "anything Less Than 7"?

Originally Posted by OllieB

Try this

Please Login or Register  to view this content.

One more question. If I have a blank Row how to I get this Code to Skip that row and continue?

Originally Posted by OllieB

Yes, it can. The only thing you have to do is change the following line of code

Please Login or Register  to view this content.

Entire Row will be blank. Unles you know a way to have the Code above insert a blank "Unhighlighted" row after each Unique Prod ID. So it will look like the attachment below. I know I could do a conditional format but I'd like to eventually get this ALL to run by hitting 1 or 2 buttons.

Attachment 207860.

Originally Posted by OllieB

will the entire row be blank, just a few columns, the date column?

I figured it out by recording a Macro doing the Conditional Formatting. Then I created a "CallAll" Macro that "Call" each Macro after one has run.

Originally Posted by mjfox52610

Entire Row will be blank. Unles you know a way to have the Code above insert a blank "Unhighlighted" row after each Unique Prod ID. So it will look like the attachment below. I know I could do a conditional format but I'd like to eventually get this ALL to run by hitting 1 or 2 buttons.

Attachment 207860.