microsoft excel - Using IF and ISBLANK statement to determine a range of cells if any of them have information in them

I have a formula where I am checking for a range of cells whether or not they are blank.

If all of them are blank I want to return another blank.

If any of the cells in the range are not blank, I want to return a value Major Milestone Due.

Here is the formula I currently have:

=IF(ISBLANK(BM2:BQ2),"","Major Milestone Due")

It is returning everything as Major Milestone Due, even if there are certain row ranges with all blank cells.