Hi guys,

Test file

In the test file above I'm trying to do a conditional formatting of a cell depending on the column/row values entered in the green columns. I only succeeded doing so for one entry, but I need to make it work for several values (theoretical max. = 150), so several cells should 'light up'.

Could somebody help? Or has someone a different approach?