how to format (conditional formatting) a cell that reaches a certain % before a given date

I have a set of data that contains % completion of a project and target dates. The goal is to format a cell (let's call it "status" cell) as follows:
red - 90% Loaded (column G) 12 days prior to "Input date" (column B)
orange - 90% Loaded (column G) 18 days prior to "Input date" (column B)
green - 90% Loaded (column G) 21 days or more prior to "Input date" (column B)

Is there a way to determine that given the attached data and format column H?

I'm trying this formula instead so conditional formatting can be easier and based only on the values in the cells. However, there's an error in my formula below. Can someone help me get the values in my analysis below?

Formula:

Please Login or Register  to view this content.

Parameters
I7 = %closed
F7 = Input Date

ANALYSIS:
AND(I7>0.9,(F7-19)>TODAY())),"GREEN",
if % closed is more than 90% at least 19 days prior to input date = status green

AND(I7>0.9,(F7-18)>TODAY())),"AMBER",
if % closed is more than 90% less than 19 days prior to input date = status amber

AND(I7<0.9,(F7-15)>TODAY())),"RED"
if % closed is less than 90% less than 15 days prior to input date = status red