View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
thisisjampers
 
Posts: n/a
Default 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.