Conditional Format Based on Date and Source of Text

I'm trying to put together and aggregate Gantt chart to track the progress of several Gantt charts that are running at the same time but all are separate sheets in the same workbook.

H33 = Actual End Date
J33 = Timeline End Date

If there IS a date in the H33 field, I want to populate that with the formula below.
If there is no date in the H33 field, I want to populate the date that IS definitely in J33
This part all works fine with the following formula:

=IF('SheetName'!H33="",'SheetName'!J33,'SheetName'!H33)

Here's what I'm looking to do next though.
I want to get conditional formatting to fill the cell green if a date was pulled from H33 (this means job is actually done so it's off our radar)
If it pulls the date from J33, I would like it to turn Yellow if we are currently within 1 week of that date coming up and red if we are 3 days from that date.

Does anyone know how to set conditional formatting to do something like this?

Maybe I conditionally format the cells on the other Gantt charts and inherit whatever their conditions are on the aggregate sheet?

Attach a sample workbook with your expected outcomes.

Go Advanced then Manage Attachments then Upload.

Okay, so take a look at this. The Osage Beach line in the Project Progress Sheet...
I want cell D3 for instance to pull either I33 from the Osage Beach sheet or K33 if I33 is blank.

When you look at the Osage Beach sheet, row I should fill green anytime a date is filled in.
Row L, I will want to turn yellow if current date is within 1 week away and red if it's 3 days away or has already passed.

Then I just want whatever is conditionally filled in on the Osage Beach page to also fill in on the Project Progress page.