format cell based on previous one
I'm using conditional formats to seperate groups of data. For example, when
the content of a cell in column A changes from the previous row to the next,
the conditional format puts a bold border on top (as opposed on a light
border). The problem arises when I insert a row. Then every comparison below
that new row compares to 2 rows up, not 1 row up.
Ideas appreciated.
|