Highlight empty column

I am trying to highlight all the cells of an empty column with conditional formatting, but while applying =isblank($x2) or =$x2="" on =$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.)

1 Answer

=COUNTIF(x:x;"<>")=1

should give you TRUE iff the column is empty but for the header

Edit : removed the dollars in my formula as was suggested in the comments, this fits better the initial question.