Im working on a comparison on figures from 2004 compared to 2003 figures

example

2003 figure 15182.39 cell 2003!d7

2004 figure 20857.12 cell 2004!d7

difference 5674.73

and was wondering if any of u could help..

how can I show the 5674.73 as a percentage?

Can I make the percentage red if in minus? (if figure is in minus)

As I don’t have many figures for 2004 is there a way to get the formula to ignore if both figures are not greater than 0.00 or one of the cells is empty.

Thanks as always..

Davie.