Macro with Conditional Formatting to color row based on date column

I have a report that runs every day (same columns) with project dates from from today thru weeks into the future. We need to be able to review the projects due in the next 14 days, every day the report runs.

I know how to color rows based on the value in a cell with conditional formatting, but I can't figure out how to make this work in a macro.

We need to use a different RGB value for each day (today((), today()+1, today()+2, etc.)

If i can get code for "today()", (RGB value 255,0,0) then I can copy that and adjust it for the next 13 days.

The report varies in the number of rows (hundreds to a few thousand), and is 35 columns wide.

The Date column is Col D.

We won't need to clear any formatting, as the report runs every day, and we will only run the macro once a day.

Grateful for any help available.

Why does this need to be in a macro vs. a conditional format?

If you could attach a small example that would be helpful to trial on.

If you're able to attach an example, please mock-up up the results you want so it's clear what you're shooting for.