Sat, 9 Jun 2007 13:06:42 -0400 from Stan Brown
:
Sat, 9 Jun 2007 08:57:57 +0100 from <"David Biddulph" <groups [at]
biddulph.org.uk:
Are you sure that you've got relative addressing and not absolute
addressing? If the formula in all the rows referred to X4 when you format
painted it down, then I expect that your formula referred to X$4 or $X$4,
rather than to X4.

Yes, I'm very sure it was X4 and had no dollar signs. I would have
expected the cell references to update as they do when copying
regular formulas, but they didn't.

Mystery solved!

Here's what I think the problem was. I no longer have the test
worksheet, but I *think* I typed the conditional-formatting formula
as
x41.2*w4
instead of
=x41.2*w4

I didn't notice it in my original test, but just now when I tried it
I see that
x41.2*w4
gets converted to
="x41.2*w4"
which of course will not change when copied to another cell.

I've verified that
=x41.2*w4
*does* change appropriately when formatting is copied to another
cell, just as David said (and as I would have expected).

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/