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.
Bookmarks