I have a spreadsheet of technicians that I am working on that needs to evaluate a techs level before applying conditional formatting based on performance level.

For example:

I have a level 1 technician required to maintain specific performance levels. If he's at goal it's green, between two numbers is yellow and too low is red.

The catch here is if the technician is a level 2, the required performance levels will change based on that tech level.

How would I create a formula to test the technician level, then apply conditional formatting to the adjacent cells based on that tech level?