I would like to get a cell in a particular row above the current cell.
This is to be used in conditional formatting, so I can't specify a particular cell, e.g.
A$4—the reference would be the same for whole range.
What I need is something like:
GET_CELL_AT( COLUMN(CURRENT_CELL), 4 )
What I use it for is to color a cell red if it's bigger than a treshold in the other cell.