Excel conditional formatting error

[Bob]

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

[Duke Carey]

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

[pikapika13]

I wouldn't assume its a bug until we see the specifics of your conditional formatting. If you referenced another cell, it could be an absolute vs. relational issue. Most of the time, Excel will do EXACTLY as you tell it--sometimes too well. So, please post your example.

[Bob]

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

[David McRitchie]

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" <Bob@discussions.microsoft.com> wrote in message news:9EDB26F3-4D94-454B-AA9D-803838168702@microsoft.com...
> 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

[pikapika13]

what does row10 say in the conditional formatting after the insert?
And does paste work better in Excel 2000 instead of "insert copied cells?"

[Bob]

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" <Bob@discussions.microsoft.com> wrote in message news:9EDB26F3-4D94-454B-AA9D-803838168702@microsoft.com...
> > 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
>
>
>

[bj]

do you have the same problem with <file><cut> and <insert><cut cells>?

"Bob" wrote:

> 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

[Bob]

Never tried that. My current spreadsheets are all conditional by row.

What gets me is that this is a bug, but I would even have to pay Microsoft
to ask them about it, much less never get it fixed.

"bj" wrote:

> do you have the same problem with <file><cut> and <insert><cut cells>?
>
> "Bob" wrote:
>
> > 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

[Gord Dibben]

Bob

FWIW, I can't replicate this behaviour in Excel 2002 or 2003.\

Enter 1 to 10 in A1:A10 then CF those rows with =$A1<6

Rows 1 to 5 turn yellow(my choice of color)

I cut row 5 and select row 15 and "Insert cut cells"

Rows 1 to 4 retain the formatting.

Row 14 is now formatted.

Row 10 is not formatted because it has no CF attached(it used to be row 11 and
we didn't CF it originally).

Maybe I misunderstand the problem you believe you're seeing?


Gord Dibben Excel MVP

On Tue, 10 May 2005 15:38:05 -0700, Bob <Bob@discussions.microsoft.com> wrote:

>Never tried that. My current spreadsheets are all conditional by row.
>
>What gets me is that this is a bug, but I would even have to pay Microsoft
>to ask them about it, much less never get it fixed.
>
>"bj" wrote:
>
>> do you have the same problem with <file><cut> and <insert><cut cells>?
>>
>> "Bob" wrote:
>>
>> > 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