Colour fill of empty cells in a dynamic range

What does "title block" mean to you? To me it means row 1 through 4 which I don't think you mean. Specifics is king in this kind of stuff.

Thanks for noting my shortcomings :-)

I mean Rows 1 - 3 on row 2 either side of the text as I have 4 sheets that fill similar to this and some have say cells B2, C2 and H2, J2 empty

Hope that makes sense

Thanks for noting my shortcomings :-)

I mean Rows 1 - 3 on row 2 either side of the text as I have 4 sheets that fill similar to this and some have say cells B2, C2 and H2, J2 empty

Hope that makes sense- have put the "here's one I prepared earlier" attachment - which I did by "hand"

Report 2.jpg