Why is my conditional formatting rule not working?

[nithchun]

I'm trying to create a conditional formatting rule where it goes through every column, discluding the header, and check if the column has any active cells using COUNTA, and if it doesn't, it should highlight the whole column red. However, it is not working even though I think the formula is correct. Here is my formula. I would appreciate any help on this.

=COUNTA(A:A) = 0

with the whole dataset as the range, without row A1 to disclude headers.

 

[DanteAmor]

How about:
=COUNTA(A:A)=1
Applies to: =$1:$1048576

Dante Amor
	A	B	C	D
1	Head1	Head2	Head3	Head4
2	data		data
3
Hoja3

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
1:1048576	Expression	=COUNTA(A:A)=1	text	NO

 

[nithchun]

How about:
=COUNTA(A:A)=1
Applies to: =$1:$1048576

Dante Amor
	A	B	C	D
1	Head1	Head2	Head3	Head4
2	data		data
3
Hoja3

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
1:1048576	Expression	=COUNTA(A:A)=1	text	NO

 

[nithchun]

Thank you, that worked! I don't know why this worked and the other solution didn't but appreciate your help!

 

[DanteAmor]

I don't know why this worked and the other solution didn't

It is because the formula counts the entire column, so if you have a header the result is 1, it means you have the header and no more data.
So = 1 turns the column red. = 0 does not make it red, because 0 is not equal to 1 and greater than 1 means that there is more data than the header.

I hope it's clearer now