Automatic cell colour change after 14 days

Hello all,

I am new to the group, and a beginner in excel.
Can someone help me with the formula please?

I need cells in column E to change colour to RED automatically after 14 days from the date in cell.( as a reminder that specific order needs chasing up) , Is it possible to change RED back to no colour once column F is filled ?

pic1.png

Thank you.

Hi -- can you attach your actual file rather than a screenshot?

I have used conditional formatting form other post on forum , but can not get column F to work.

Here you go:

Make a new rule
=NOT(ISBLANK(F1))
Format no fill color.

Thank you all works great!