I've developed a formula for a workbook "=PRODUCT(SUM(E7:E16),1/SUM(D7:D16))"

Now i want to make that cell blank for next or new dates as they giving some result
and its disturbing the Conditional formatting (Color Scales).

So what changes should i made to this formula.
This is my first workbook so please help..!!

Also the cell is showing error but giving the result fine.

Book1.xlsx

Thanks in advance.