Weird Conditional Formatting Results

[Roncondor]

Hi

I have a few weird situations with conditonal formatting in 2007. I want to change the formatting on a group of cells depending on the contents of a different cell.

For exampe "=OR(C25>0,C26=TRUE)" applies to range: "$C$27:$C$31"

However,

1. Sometimes it does not work until I either
a. enter the cell and then leave it -or-
b. Do Print Preview

2. Sometimes it does not work for ALL of the cells (C27 seems to act independently) [there are no other conditional formatting rules on the cells]

3. Sometimes it does not work at all.

Thanks
Ron