I am developing a type of import template. In which I would like a color coding to indicate which cells they need to fill in dependent on another cell and its drop-down list. 

Given the value in column L, I would like the columns O:BV to change colors.

I have made it to work for one cell with formula:
=count.if(Blad2!$B:$B;L7)>0

But can’t get the as in this instance L7 to change for L8 and so on. With this formula my thought was to make one for each column O:BV, but perhaps there is a better way?

Blad2 looks like this:

​I am developing a type of import template. In which I would like a color coding to indicate which cells they need to fill in dependent on another cell and its drop-down list.  Given the value in column L, I would like the columns O:BV to change colors.I have made it to work for one cell with formula:=count.if(Blad2!$B:$B;L7)>0But can’t get the as in this instance L7 to change for L8 and so on. With this formula my thought was to make one for each column O:BV, but perhaps there is a better way?Blad2 looks like this:  Read More

​