Automatic formatting of cells based on rules/criteria

[ioannes]

ok guys, difficult one here:

I have a long set of data that I extract a "table" out of based on index matching controlled by 4 different criteria. This part is working as intended. However I need to format the cells with the corresponding "fetched data" based on another criteria. Makes sense? Have a look at a spreadsheet i made representing my problem. It has comments for the problems.

Whoever helps me with this gets a +1 internet and also a +1 excel!

[ioannes]

shameless self-bump