I have a data range, B7:L38. Within this range, I want to check if
there is any value from F7 to L7. If there is a value on any cell
within F7 to L7, I want to make sure there is a value on B7 and E7. If
not, I will display a message in cell B7 and E7.

I need to do the above check from every row from 7 to 38.

How do I do this? Thanks.