Conditional formating for dynamic area containing data

[Nav_M]

Hi,

I'm trying to create a output of data with conditional formatting, the basics of this is working fine. However I need to upload this spreadsheet to confluence, which has an issue with conditional formatting. If any cells covered by conditional formatting don't contain data, confluence will throw an error. I've got the conditional formatting working, but I have to select the area manually, if people add columns or rows then the display on confluence will break.

SO what I'm trying to do is have conditional formatting apply to an area starting from column D and go across to the further column on the right until the table stops and row 2 until the last row containing data. Note: there is further information after an empty column, I don't want this included...

Any ideas on how I can select the area dynamically?

Thanks
Nav