Conditional Formatting Not Working Consistently

[Guest]

One of our Excel users is applying conditional formatting on cells within a
worksheet that are linked to other worksheets in the same file and he is
getting inconsistent results i.e., sometimes it applies the formatting and
other times it won't. He seems to have the problem primarily when he selects
a range within a column and then applies the conditional formatting.

The conditional formatting statement applied to cell C5 is:
Formula is =$B$5-$C$5=0 then format as red and bold.

He is concerned about the ability to rely on this feature working properly.
Since he is our Accounting Manager, he would like to use this feature
extensively to produce a variety of management reports.

Any suggestions?

 

[Anne Troy]

This formula creates a circular reference as a regular formula, so I
wouldn't expect it to work for a CF formula either.
*******************
~Anne Troy

www.OfficeArticles.com

 

[Guest]

That's what I thought, too, when I looked at the formula. But it does work as
I tried applying it to a single cell.

 

[Alan]

Anne,
The circular reference reference does not apply here I dont think. I tried
this formula as it stands in the mail and it does work.
Regards,
Alan.

 

[Guest]

Hi Earl:

Funny, you would say that because when I asked him to show me what he was
doing, it worked. Likely, he had just switched worksheets.

I will pass this along to him and see how it goes. Thanks.

By the way, the attachment didn't come through.

 

[Earl Kiosterud]

Christina,

Switching worksheets seems to make the CF display properly with the current
CF conditions, but if the conditions change, it can fail again.

The picture I attached came through in the microsoft news group. I'm
connected directly, in Outlook Express. You're using the web -- they
probably didn't let it through.

Some while back several of us bandied this about in one of these newsgroups.
It was never resolved, as I recall. I'm hoping more folks will weigh in on
this. It seems an unresolved problem.