Formula query

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtraction of 2 numbers/cells 3
cell display 2 4
time formulas 2
Cell colour in relation to IF results 2
COLOR CODING A PROFIT & LOSS SPREADSHEET 1
conditionally formatting colour of cells 2
Negative time displaying as ##### 7
Changing Celll colour as a result of a calculation 2

Top