Autofill a cell once data has been entered?

Hey guys,

I've a sheet here which uses a formula to calculate a future date. If no data exists in the row then the cell displays blank.
When a user enters data and this future date is calculated is it possible for excel to autofill this newly populated cell in yellow?

Thanks guys!
Manolis