Trend of last five results

Hi,
I've done this spreadsheet and i want it to trend the previous 5 results and target. well i've got the formula to work but for some reason when i use the if statement to show a blank cell unless there is something in the row in column A then conditional formating does not work in columns G,H,I,J.

but if i remove if statment then i get #value! until the relevant info is in column F.

How can i correct this ?