Placing Icons
Hi,
For Excel 2007:
Assuming Previous is in Column A and Current is in column B
In column C use the foruma:
=IF(ABS(A2)<ABS(B2),1,3)
For these cells us Contional Formating with 3 colored arrows.
Change the properties so only pictograms will be shown.
HTH,
Wouter
|