Hi

I have this formula which produces an estimated purchase price from a selling price...

=(F4-3.95-((F4-3.95)*0.2))

I need this to operate only when F4 is filled, otherwise I get a minus figure for a sale that hasn't happened.

Eventually the result figure will be replaced by an actual figure, so is there also is there a way I can force this estimated result to show in red?

Thanks