I'm part of a mailing list that writes tournament schedules. We use
conditional formatting to highlight only one team's games when that team is
selected from a drop-down list. Anyway, something weird has started
happening. If I load up the latest version posted to our list and do the
following:

select three cells (relating to a game, M2vM3)
press Alt+o; d; to open the conditional format dialog

Then I see '=$d$3<1'

Then click 'OK' without doing ANYTHING else,
reselect the cells,
Alt+0; d; again

and now I see '=AND($D$3<1,$D$3<48,$D$3<49)' which incidentally is the
condition that's supposed to be in there.

So basically, just by looking at the conditional formatting, I cause it to
change. Is this some kind of quantum effect? ;)

I'm using office 2000 on vista, and I know there are problems with that, so
I asked some folk on the mailing list to see if they got the same thing. They
all did, using office 2003 on XP, 2000 on XP, and spectacularly, one guy on a
Mac.

It's a cross-version, cross-platform absurdity.

Any ideas?

B

Benji,

Try looking at the conditional formatting for one cell at a time. Repeat your test. Might
shed some light.
--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------
"Benji Heywood" <Benji wrote in message
...
I'm part of a mailing list that writes tournament schedules. We use
conditional formatting to highlight only one team's games when that team is
selected from a drop-down list. Anyway, something weird has started
happening. If I load up the latest version posted to our list and do the
following:

select three cells (relating to a game, M2vM3)
press Alt+o; d; to open the conditional format dialog

Then I see '=$d$3<1'

Then click 'OK' without doing ANYTHING else,
reselect the cells,
Alt+0; d; again

and now I see '=AND($D$3<1,$D$3<48,$D$3<49)' which incidentally is the
condition that's supposed to be in there.

So basically, just by looking at the conditional formatting, I cause it to
change. Is this some kind of quantum effect? ;)

I'm using office 2000 on vista, and I know there are problems with that, so
I asked some folk on the mailing list to see if they got the same thing. They
all did, using office 2003 on XP, 2000 on XP, and spectacularly, one guy on a
Mac.

It's a cross-version, cross-platform absurdity.

Any ideas?

B