Conditional formatting to cover range following merged cells

[[email protected]]

Hi,

In the attached file, I want to modify the conditional formatting in such a way that the format will cover the range covered by the merged cells in column F. For example, column F4:F6 have the value "B". Currently, only columns where rows 4-6 are merged show the conditional format. I want a situation where the conditional format will cover Range A4:G6.

I hope my explanation is clear enough.