[Solved] IF a cell is blank use info from another

[Martync70]

Hi

I'm trying to make up a project budget spreadsheet
What I want to do is have 2 columns 1st having an estimated cost (cell D4) and the second having the actual cost (cell F4)
What I want to be able to do is use the cost from Cell D4 if there is nothing entered in F4, and ideally have the color different (ie RED) to indicate its still an estimate not an actual cost.

Have played around with IF statements but always get an error.

Thanks in advance
Martyn

[robleyd]

You don't say what formulae you have actually tried; but one solution might involve IF() and ISBLANK().

My answer to a very similar question two days ago is in this post.

[Martync70]

Great works as wanted
Many thanks