Help with conditonal formatting

Hello,

On our work tracker we have a 10 business day turnaround to get work completed.

Currently we have a formula that works out how long it has taken to complete a task and using conditional formatting this displays the cell in black if it goes above 5 business days.

I have used the 3 conditional formatting conditions to do the following: -

- Cell Value - between 4 and 5 - Display green colour

- Cell Value - equal to 3 - Display Amber

- Cell Value - less than or equal to 2 - Display Red

I've input this formula into the column to work out whether the task is going to expire or not.

=IF(I4="","", IF(NETWORKDAYS(TODAY(),WORKDAY(E4,10)) <0, "Out of KPI",NETWORKDAYS( TODAY(),WORKDAY(E4,10))-1) )

- E4 is the received date (the date from where the 5 days begins)

- I4 is the complete date

I want the countdown to disappear when the task is complete but using "IF(I4="","".....before the 2nd IF statement it should technically make the cell for the countdwon disappear. However it is still displayed when a date is entered but disappears when I4 is blank!

What am I doing wrong?

I have a test file which I can send if its easier. Please can anyone help?