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!!!