I have a column directly to the left of the pivot table that feeds the conditional formatting for each row in the pivot table.

Row A contains hours per week an employee works, row B begins the pivot table and contains the employees name, Row C are the total hours, the remaining rows are dates which represent weeks and are a sum of the hours for that week.

If the cell value (total hours) is less than the hours in row cell A# it is green but if the hours are more than row cell A# then it is yellow.

When a new employee is added on the Data Source I want Excel to insert a row in cell A where the employee is added in the pivot table.

So far I am drawing a blank as to how to achieve this.

Please HELP! THANK YOU in advance.