Thanks for the reply, I'm afraid I can't upload it as it's a work doc.

What do you mean by using conditional formatting on my formulas?