Help with formula....

[rpsrery]

Okay, so I have what I thought was going to be an easy formula and now my mind is spinning out of control with =if...

Here is what I am trying to do

I have a Gantt chart, below are the columns of data I collect

A - Task Name
B - Resource Name
C - Start Date
D - End Date
E - ( I am using =networkdays(a2,b2) to determine the work days from start to finish)

F - % of time allocated to the task

Here is where I have the issue. In may cases there may be one resource, who has tasks that overlap one another, and the % of time allocated may exceed 100% during that time. I want the Gantt bars which currently are red to turn green in the overallocated, overlapping dates or somehow flag the tasks assigned to that particular resource when this does occur.

Any help, suggestions would be greatly appreciated...

chart is attached below...

[gunrgraham]

This is how I would do it.

If you want to add more rows, select row 14 and insert.