Conditional Formatting based on sum of values in multiple columns/rows

I have a spreadsheet that tracks resource allocation over each month. Each month is a new column and a single resource can appear on multiple rows (if they are split amongst workstreams).
I have applied conditional formatting to highlight the resource allocation figures in red when a particular resource is overallocated.
I would also like to apply this formatting to the resource name, however when I expand the conditional formatting range, the incorrect fields are highlighted.
I am stuck at how to modify this rule to cater for this or create a new rule just for the names column.
I appreciate and thank you for your assistance in advance.
Please find a sample spreadsheet attached.

Hi JeteMc,
Thank you for your reply.
Whilst the approach works, the name list is constantly changing so I need a method that I do not have to maintain. Perhaps VBA would provide a better solution, I will keep researching.
In the meantime I will keep this thread as open should there be any other solutions out there.
Regards

I ended up using a slightly modified version of JeteMc's suggestion and utilising VBA to automatically apply it every time a row is modified in the source sheet (to cater for the constantly changing list).