I found a rather simple formula to recognize empty ranges. It goes like this:

=IF(ARRAYFORMULA(AND(H5:H36="")),"empty","not empty")

Where H5:H36 is a sample range (a column in this case), and "empty", "not empty" can be replaced with other statements.