Hi there everyone,
I am new to this but am looking for help with some conditional formatting and formulas.

If cells A4 & C4 are blank then cell E4 needs to be red. If there is a date entered in cell A4 then cell E4 needs to turn amber. If there is a date in A4 & C4 then E4 needs to turn Green.

I hope this makes sense and that someone can help me.

Many thanks