If cell contains 'text' then another cell will automatically contain 'SUM'

[AngieBramley]

Hi All,

I’d like to create a formula that would mean………
If the word ‘float’ is inserted into a cell in column C then………….
Column E & F will automatically add up the totals above and…………
Column G will be the sum of E-F

(an example of the end result being in row 7)

any ideas?

Thanks

Edit: I forgot to add that also if a cell does contain the word 'float' then it automatcally turns grey too :S Thanks