I don't seem to have the proper understanding of how to handle
conditional formatting in Excel 2007. Let me describe two scenarios
that I have toruble with and I'm interested to know how I'm supposed
to work with this useful feature.

I create a conditional format (formula) in cell U3 that depends on
values in row three, like E3 and also cell U1 referred to as U$1 in
the formula. After being satisfied with it's operation I copy and
paste special formats to cells in column U below row 3, say U4 through
U100. Again the format seems to work fine on all cells. But if I go to
cell U50 and look at the formula the cell references do not seem to be
the ones I would expect to see (still refers to E3).

The other problem I have is when I copy and paste special formats a
conditional format from one cell to another cell that already has a
conditional format, the target cell will have retain the original
conditional format and the new format pasted from the other cell. This
isn't the way 2003 worked.

Am I just not understanding what changes were made in conditional
formats from 2003 to 2007?

At this point I find myself actually going back to Excel 2003 when I
need to do some serious work with conditional formats.


John Keith