I understand about confidential data. And in this case perhaps we can figure it out using just words. But a five-row sample with dummy data can sometimes make a situation a lot clearer.

Don't forget my question below: Do you want your program to color each row based on the value in col L of that row? Or do you want it to color (for example) A2:L11 based on the value in L2? I thought at first you meant the latter; do you mean the former?