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


"Anne Troy" wrote:

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


"Christina" wrote in message
...
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?
--
Christina