Highlight Cells using Macro for Dates

[jharvey87]

Hi Everyone,

Using an excel add in, I'm pulling in data from an internal database. I want to create some conditional formatting type features, but they have to be macros. When the data is refreshed, it creates new ranges and the conditional formatting becomes messy. Certain ranges are missing, etc.

When I run the macro, it would check columns C4:C (Award Date) and D4:D (Start Date) for the following:

- Orange Highlight: Date is within 15 days of Today's date.
Example: Today is August 7, so anything within August 22 shown would highlight.
- Yellow Highlight: If the start date (column D) is a date that occurs before the date listed in column C. So column D cannot be less than column C.
- Blue Highlight: If the date range between the two is not greater than 30 days. So if D-C is not > 30 days, it would highlight. 7/1/18 to 8/1/18 would be no highlight.


I can try to place with this if someone can get me started. If the different colors are problematic, then it can all be the same yellow highlight. I'm having a really hard time understanding how to highlight based off dates within VBA.

Thanks for the help.

[mehmetcik]

You should be using conditional formats.

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.