Thread: Formula query
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
IoHeFy IoHeFy is offline
external usenet poster
 
Posts: 12
Default 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