How to check if a column has any cells with data

[excelactuary]

Hello!

Is there a way to highlight data in a column? Let's say I have a long column, where I want to check if there are any cells with data in it. How do I do this?

Thanks,

excelactuary

[Jakobshavn]

If column D has no data then

=COUNTA("D:D")

will display zero

[Ron Coderre]

Here's something to try:
• Select the Row_1 cell of the column
• Press: END Press: Down Arrow
That will find any cell with contents...or it will select the last possible row of the column

or to simply test if any cell has contents:
This regular formula returns the count of non-blank cells in Col_A: =COUNTA(A:A)

If you want to flag them, try Conditional formatting using this kind of formula test: =COUNTA(A1)

Does that help?

[Naidonis]

Or you can press CTRL+Arrow and it will select the nearest cell that is not empty in that dirrection.

[excelactuary]

Thank you for the excellent advice!