Conditional formatting based on Name and individual set %

[bljohnson07]

Conditional formatting based on a column and TC Name.

Example table below: [TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]TC Name[/TD]
[TD]Project[/TD]
[TD]Ave Load[/TD]
[/TR]
[TR]
[TD]TC1[/TD]
[TD]0[/TD]
[TD]0%[/TD]
[/TR]
[TR]
[TD]TC2[/TD]
[TD]25[/TD]
[TD]218%[/TD]
[/TR]
[TR]
[TD]TC3[/TD]
[TD]7[/TD]
[TD]44%[/TD]
[/TR]
[TR]
[TD]TC4[/TD]
[TD]16[/TD]
[TD]114%[/TD]
[/TR]
</tbody>[/TABLE]

So I was giving a R/Y/G fill for the percentages in the "Ave Load" column based on the TC name (because they can be different for each cell) and I was able to do that using a vlookup in the cell value box powerpivot table. I used the TC name and if it was over the max % listed in the table it codes it Red, if it was between the max & min % it is green and anything under the min % is yellow. Worked great.

Moving everything to Power BI I cannot figure out how to do the same and I would like the same table in my reports. I hope I am explaining this well enough so you fine folks can probably tell me I'm over complicating it and help point me in the right direction. Any help is appreciated. Thanks