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?
Bookmarks