Need some help. Just switched to Excel 2007 and things seem to be
different.

Have a Range of cells of about 20 x 20. Two other cells, A1 & B1, have
numbers in them.

My conditional formatting is set up such that if any of the cells in the
Range = A1 it gets filled with one color, if it = B1 it gets filled with
another color, and if it < OR(A1, B1) it gets no fill color.

Nothing happens when I change a value in either A1 or B1. But if I switch
to another Tab and then switch back, the conditional formatting is correct.
What am I missing?

Respectfully submitted,
Bob Myers