Excel conditional formatting error

B

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
 
B

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
 
D

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.
 
B

Bob

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

Bob

David McRitchie said:
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 said:
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
Click to expand...
Click to expand...
 
B

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.
 
G

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
 
B

Bob

Gord,

You got the idea right on. The problem occurs in Excel 2000. Unfortunately
that is what we have at work. I have 2003 on my laptop and it works fine,
but 2000 is wacked. Our techies have loaded SP3, but apparently Microsoft
never fixed the bug.

Bob
 
G

Gord Dibben

Bob

I thought I read that you said 2003 also had a problem.

Re-reading proves that once again re-reading is a good idea<g>


Gord
 
Top