Conditional formatting according to the value of another cell and four different condition

Hi all

I hope, this time my post title is concise and explicit.
I found a lot of conditional formatting similar to what I need but none so complex, so I tried to apply a conditional formatting based on the value of another cell with multiple conditions.
I will try to explain.

In column D I have a list of types. A list of 61 total different types, that can appear as duplicates and not in order.
For each type in column D, I have 4 different values in 4 different columns E,F,G and H.
The column where I want to apply conditional formatting is column D in the following form:

If D2 =1 and meets the conditions applied for Val 1 (column E2) - than D2 should become color yellow; If D2 =1 and meets the conditions applied for Val 1 & Val2, than D2 should become light green ; If D2 =1 and meets the conditions for Val 1&Val2& Val3, than D2 should become green; and lastly...if D2=1 and meets the conditions for Val 1&Val 2& Val3& Val4...it should turn red.
If D2 =2 and meets the conditions applied for Val 1 (column E2) - than D2 should become color yellow; If D2 =2 and meets the conditions applied for Val 1 & Val2, than D2 should become light green ; If D2 =2 and meets the conditions for Val 1&Val2& Val3, than D2 should become green; and lastly...if D2=2 and meets the conditions for Val 1&Val 2& Val3& Val4...it should turn red... AND SO ON FOR ALL 61 TYPES.

On the right I have an example of conditions that each column ( VAL1, VAL2, VAL3 & Val 4) have to meet.
NOTE : Each TYPE (1-61) has different conditions to meet for each VAL (even if in the table is not).

I'm sure it's not easy even for someone with good knowledge of excel, and practically impossible for me to solve something like this.
Thanks in advance.

Hello
Can we change the format in which you type the condition?
i.e. in column M instead of repeatedly writing >=20 can we just write 20 if the condition is same for all the numbers??

Thanks for your quick intervention sourabhg98.
The problem is that the condition is not identical for all types.
May occur different types have the same value for condition. But are different types.
The table on the right is just to explain, the real values may be different.

But if you want to do a test ..you're welcome.

So this means that instead of greater than or equal to it can be smaller than too in the column m or o?

Unfortunately ... but please, expose your idea, saying that the values are greater than or equal.
Maybe if we can use something like VLOOKUP FOR D2 in the table to check the condition.
Maybe I say something stupid

Or maybe another approach ??

Ok, So I gave a try
please check the attached file...if this was what you required...
Column Q to AA are all formulas....

Hi sourabhg98

First I want to thank you for your help and apologize for my late response, but I had to check well if is exactly what I need. And yes, it is exactly what I need.
I like your approach and I must admit that you did an excellent job.
Many thanks again.

You are most welcome!!
Thanks for the reputation!