Format painter would help me fix the problem, but won't prevent it. Nice
thought, though.

Bob

"David McRitchie" wrote:

Hi Bob,
You could use the format painter, and wipe out the formatting you don't
want also with the format painter toolbar icon.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Bob" wrote in message ...
The conditional format really doesn't matter. As an example, say you have 10
rows with column A having 1, 2, ... 10 in the cells. Then you add a
conditional format for those 10 rows that has formula = $a1<6 (with the
number 1 being the first row and the others are rows 2..10.

Then right-click row 5, and select "cut"

Then right-click row 15 and select "insert cut row"

In Excel 2003 rows 1..9 look fine, as does row 14. (yeah, we inserted at
15, but when 5 was cut 15 became 14)
In Excel 2000 rows 1..9 look fine, but row 10 has formatting and shouldn't.
Row 14 isn't right, and row 15 has formatting.

I wish I could attach a simple spreadsheet.

Bob

"Duke Carey" wrote:

Please provide specifics about the conditional formatting you've applied


"Bob" wrote:

I am using Excel 2000 and have conditional formatting set up for most, but
not all rows. Works great, except that if I right click a row, then select
"cut row" and go somewhere else, right click and select "insert cut row," the
formatting doesn't move. In fact every format from the "cut" on down stays
the same.

Anyone else experience this? Is there a fix? Definitely a bug, but I
haven't seen a fix anywhere.

Thanks,

Bob