[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]User ID
[/TD]
[TD]Amounts
[/TD]
[TD]Posting Date
[/TD]
[/TR]
[TR]
[TD]11
[/TD]
[TD]$500
[/TD]
[TD]2017.07.24
[/TD]
[/TR]
[TR]
[TD]11
[/TD]
[TD]-$150
[/TD]
[TD]2019.04.05
[/TD]
[/TR]
[TR]
[TD]11
[/TD]
[TD]-$200
[/TD]
[TD]2019.05.10
[/TD]
[/TR]
[TR]
[TD]11
[/TD]
[TD]$200
[/TD]
[TD]2019.06.24
[/TD]
[/TR]
[TR]
[TD]11
[/TD]
[TD]-$350
[/TD]
[TD]2019.06.25
[/TD]
[/TR]
[TR]
[TD]11
[/TD]
[TD]$600[/TD]
[TD]2019.09.03
[/TD]
[/TR]
[TR]
[TD]11
[/TD]
[TD]-$100
[/TD]
[TD]2019.09.07
[/TD]
[/TR]
[TR]
[TD]11
[/TD]
[TD]-$200
[/TD]
[TD]2019.10.03
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I there a way in which I could automatically identify the bolded cell? I have a list of 40,000 lines, with each line item identifiable by a USER ID, and a posting date... accompanied by a transaction amount. What
I want to do is highlight the cell with the date for the oldest debit transaction that has not yet been summed
down to $0. In the example above, the initial debit of $500 is no longer due... as debits and credits since then
have equaled $0... Therefore, the $600 on 2019.09.03 would now be the oldest standing debit within this user ID.
I want to highlight it in excel, this is in efforts to later on simply sort by highlight colour and grab those lines
items stating that this USER ID has been due since "insert date". Is this something that is possible?
I have tried a few tings already using conditional formatting, via some IF statements, as well as had looked ad index
and match. But, so far to no avail.
Any help would be greatly appreciated.
<tbody>[TR]
[TD]User ID
[/TD]
[TD]Amounts
[/TD]
[TD]Posting Date
[/TD]
[/TR]
[TR]
[TD]11
[/TD]
[TD]$500
[/TD]
[TD]2017.07.24
[/TD]
[/TR]
[TR]
[TD]11
[/TD]
[TD]-$150
[/TD]
[TD]2019.04.05
[/TD]
[/TR]
[TR]
[TD]11
[/TD]
[TD]-$200
[/TD]
[TD]2019.05.10
[/TD]
[/TR]
[TR]
[TD]11
[/TD]
[TD]$200
[/TD]
[TD]2019.06.24
[/TD]
[/TR]
[TR]
[TD]11
[/TD]
[TD]-$350
[/TD]
[TD]2019.06.25
[/TD]
[/TR]
[TR]
[TD]11
[/TD]
[TD]$600[/TD]
[TD]2019.09.03
[/TD]
[/TR]
[TR]
[TD]11
[/TD]
[TD]-$100
[/TD]
[TD]2019.09.07
[/TD]
[/TR]
[TR]
[TD]11
[/TD]
[TD]-$200
[/TD]
[TD]2019.10.03
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I there a way in which I could automatically identify the bolded cell? I have a list of 40,000 lines, with each line item identifiable by a USER ID, and a posting date... accompanied by a transaction amount. What
I want to do is highlight the cell with the date for the oldest debit transaction that has not yet been summed
down to $0. In the example above, the initial debit of $500 is no longer due... as debits and credits since then
have equaled $0... Therefore, the $600 on 2019.09.03 would now be the oldest standing debit within this user ID.
I want to highlight it in excel, this is in efforts to later on simply sort by highlight colour and grab those lines
items stating that this USER ID has been due since "insert date". Is this something that is possible?
I have tried a few tings already using conditional formatting, via some IF statements, as well as had looked ad index
and match. But, so far to no avail.
Any help would be greatly appreciated.