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