Conditional formatting of a cell depending on "Hidden" status of cell above.
Posted on 2011-09-21
I'm looking for a way to format a cell with, say, a bold top line if the cell immediately above is hidden. I can find no Excel function that reveals whether a target cell is hidden or not. Am I missing something obvious or is this just not available? I was hoping for something like the "CELL(info_type, [reference])" function but I cannot find what I need i.e. "=cell("hidden",A1)"