Conditional Format - a detail field to a summarized field

Content

I have an analysis report where I list all the active positions and their FTE along with the employees assigned to those positions and their FTE. I want to compare the position's FTE to the sum of all the employee's assigned to that position FTE's and format when the employee FTE count is lower than allowed or greater than allowed. For example, the dishwasher position has 10 FTE's, however there are 11 people assigned to this position, all with 1 FTE. Color formatting the FTE would be RED because there are more FTE's assigned to the position than what is allowed.

Any ideas on how to format a sum of a column to a record column?