Complex conditinal formatting

Hello!

I am looking for some help with formulas to improve conditional formatting of a document based on an excel template of a Gantt chart to follow up on progress of current projects.

I am trying to create conditional formatting for percentage of completion of actions according to planned and actual start/end dates.

I have 5 collumns with data:
[planned start] - [planned end] - [revised start] - [revised end] - [% complete]

I want last [% complete] column to be formatted according to the dates of start/end
possible results are:
- 100% completed with delay - Formatting dark green
- 100% completed within time - Formatting light green
- 0% not started, within time - Formatting n/a (or white)
- 0% not started, delayed - Formatting red
- other % values (i.e. 10%, 75%) - Formatting graded color scale

I joined the table to the attachment

I understand the logic of the formulas, but I don't know how to resolve my issue... So I am looking for your expert advises

Thank you in advance for your help and time!!!

requires four formulas:

=and(i4=1,g4>d4)
=and(i4=1,g4<=d4)
=and(i4=0,g4<=d4)
=and(i4=0,g4>d4)

all applied to $i$4:$i$12 with the formatting in the order you described and "Stop if True" selected as in the attached.

i am having some issues... is it attached now?