Hi,

I'd like to use the excellent conditional formatting (the up/down red/green) arrows to show ups and downs from month to month in a table with multiple rows (different accounts) and with multiple columns (months).

The standard up/down arrow formatting seems to compare the cell to the average of the row, but that's not what I want. I want it to look at cell-1 and compare it to cell. If cell>cell-1 then a green arrow, if cell<cell-1 then a red arrow.

Is there any easy way to do this?