Please attach a sample sheet of your data.

What do you mean the cells contain "concatenated data"?

So let me get this straight, you want to highlight the entire range H:AL if the sum of those cells is greater than D. Is that right?