Hi folks,
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.
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.