RAG Status, please help

[Kimlou]

Hi,
So, I'm not great on excel. But i need to create a rag status based on start date (column E6), estimated completion daye (column G6) and actual completion dates (column H6). I want the rag status column (I6) to be blank when there is nothing filled out, green when the actual completion date is within the estimate, amber when the actual completion date is soon becoming due and red when the date has been exceeded. I have been trying to do this now for 2 days, to no avail using IF and conditional formatting. Can anyone please help me? Thank you

 

[Kimlou]

Thank you, this is now working. Can you tell me what formula i could use so that the rag status is blank when there are no filled out at all please if you could? It's currently green even when no dates are added. Thank you

 

[MARK858]

Try =COUNTA($E$4,$G$4)<>2 and make sure that it is the top rule.

 

[Kimlou]

That works perfectly, thank you so much for all of your help

 

[MARK858]

Happy to help and welcome to the forum.

 

[Kimlou]

Thank you ?