Conditional Formatting & Insert Rows

[Tim Penning]

The problem that I'm having is that if I insert a row, the
conditional format of the new row is the same as the row
above. Here is what I mean:
Conditional format for $D$8 - Formula Is=$E$8=1, pattern
of $D$8 is red.
Conditional format for $D$9 - Formula Is=$E$9=1, pattern
of $D$9 is red.
If I insert a new row 9, the conditional format for $D$8 &
$D$10 is fine, but the conditional format for the new $D$9
is the same as $D$8. So, when "1" is entered into $E$8,
the pattern for $D$9 is also red.

Can anyone help me out?

[David McRitchie]

Hi Tim,
Don't make the row number in the addresses in the conditional
format absolute if that is not what you want.

You could format the entire column(s) at once with
Select Column D or the entire worksheet if you want the
entire row to turn red.

If the active cell is D1 or at least on row 1 since you use $D then
your formula would be =$E1=1 pattern is red

More on conditional formatting in
.http://www.mvps.org/dmcritchie/excel/condfmt.htm

You will have to remove the old C.F. first. You can do that with
the format painter from a cell that does not have C.F. and has
normal cell formatting the same as what you want.

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

"Tim Penning" <timothy....@delphi.com> wrote in message news:077b01c36b15$72527e40$a001...@phx.gbl...

[Max]

Its because you're using absolute refs, for e.g. $E$9, instead of $E9.
Try as Conditional Formatting for D9: Formula Is | =$E9=1

"Tim Penning" <timothy....@delphi.com> wrote in message
news:077b01c36b15$72527e40$a001...@phx.gbl...

[Tim Penning]

Thanks Max and David!!

>.
>

[David McRitchie]

Hi Tim,
You're welcome, hope you looked at my page as well as just
the answer. I know just when I thought I was getting the hang of
C.F., sometimes it would work and sometimes it wouldn't and
it was all dependent on the active cell.

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

"Tim Penning" <timothy....@delphi.com> wrote in message news:0b9301c36b1f$a8f28490$a501...@phx.gbl...