Saved search question: Let's say you for example h...
# general
j
Saved search question: Let's say you for example have a list of all posting transactions that is sorted by internal ID. I want it to be more readable, by highlighting when a new transaction starts. So internal ID = 1 then all lines from that transaction is grey, internal id = 2 is white, internal id = 3 is grey and so on.. Achievable?
l
Maybe with HTML/CSS in all columns/cells with condition of "if internal ID is an odd number" (CASE WHEN formula) (you can use MOD formula I think for odd numbers, among other creative ways) then highlight the cell in grey, else no formatting 'cause it's just white anyway
j
@Luis Not a bad idea! But unfortunately, the same internal ID series goes for all transactions, no matter if they are posting or not, so it's not nothing but bulletproof..
a
I’ve done something similar using DENSE RANK to pull the first instance of a transaction so you can see every time a new transaction starts