ExcelBanter - Highlighting Has Shifted on Rows

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Highlighting Has Shifted on Rows (https://www.excelbanter.com/excel-discussion-misc-queries/116403-highlighting-has-shifted-rows.html)

Highlighting Has Shifted on Rows

In a shared document, I highlighted multiple rows last night. Each color
designating a particular meaning. Today I opened the doc the highlights I
created have all shifted down. Can anyone thing of a particular reason this
would happen? We are using Excel XP here. This problem may have created many
hours of extra work if I cannot get it back to the way it was. any ideas?

Highlighting Has Shifted on Rows

Lisa

A reason.........Someone inserted some rows?

Gord Dibben MS Excel MVP

On Fri, 27 Oct 2006 07:24:02 -0700, Lisa AGA wrote:

In a shared document, I highlighted multiple rows last night. Each color
designating a particular meaning. Today I opened the doc the highlights I
created have all shifted down. Can anyone thing of a particular reason this
would happen? We are using Excel XP here. This problem may have created many
hours of extra work if I cannot get it back to the way it was. any ideas?