Formula query
 

Hello,

I need a formula which will do the following;
1) calculate the difference between two cells (say A1 and A2)
2) display the result of that difference in colour, i.e. green if the result
is a positive figure, and red if it is a negative figure.

Help with this is grately appreciated - Thank You

Formula query
 

No need for assistance - sorted it myself. Thanks

"IoHeFy" wrote:

Hello,

I need a formula which will do the following;
1) calculate the difference between two cells (say A1 and A2)
2) display the result of that difference in colour, i.e. green if the result
is a positive figure, and red if it is a negative figure.

Help with this is grately appreciated - Thank You