I am trying to highlight all the cells of an empty column with conditional formatting, but while applying
=$x:$x results in the column highlighted, entering data in a cell only causes the cell above to lose the background color.
isblank() only seems to accept a single cell as argument.
Is there a function / formula that becomes true if all cells in a column are blank/empty?
(row 1 of the sheet contains fixed header cells.)