Hi
I've spent far too many hours at work today trying to figure out how to do a couple things and am hoping someone can help. Basically I'm dealing with registers and for example, one entry (with a particular reference number) may have several actions associated with it (which appear in different rows) and each action would have a due date next to it. What I want to do is to be able to put all the actions in one cell, and colour the actions that are complete as grey, and the ones that are late in red, and I'm really struggling.
Here is what the raw data would look like:
ID Action Description Status Due Date 3001 Description 1 Open 10/03/15 3001 Description 2 Closed 01/01/15 3001 Description 3 Open 01/02/15 3002 Description 4 Closed 01/12/14 3002 Description 5 Open 15/11/14
And what I want the output to look like is:
ID Action Description Status / Due Date 3001 1. Description 1
2. Description 2
3. Description 31. Open, Due 10/03/15
2. Closed, Complete 01/01/15
3. Overdue, 01/02/153002 1. Description 4
2. Description 51. Closed, Complete 01/01/15
2. Overdue, 15/11/14
The number of different descriptions per ID would vary from none to many, the length of each description varies significantly, and there needs to be an unlimited number of IDs that could be present in the register (i.e. I may have 200 different IDs, each of them with numerous descriptions of actions, and each of those with a due date that is either not there, is late, or is in the future, so would need to be colour-coded).
Joining the Status and Due date columns are not a problem, but I'm struggling with joining the different rows (of the same ID) and then colour-coding the necessary text within those cells.
Any thoughts would be appreciated as I'm truly stuck.
Cheers
Steve
Bookmarks