how to set up info sheet to feed into Resource Management

Haley Gehris

I have entered this data and am using it as a way to track allocations across different projects. The different projects are indicated by the different WRT #s in column 1. I need to then summarize the last 2 columns by WRT #, which I've done here in a report.

I am wanting to add some type of flag or conditional formatting to indicate when there is a variance between the "total labor hours budgeted" and the "total labor hours allocated", specifically when there is a more than 5% increase in the "total labor hours allocated" vs the "total labor hours budgeted". Does anyone have any ideas of how to accomplish this?