In previous versions of Excel I could copy a formatting to another cell and
the formula would move appropriately (as long as $ were removed from
reference) ie. =A9 would change to =A10 if copied down. In Excel 2007 I am
finding that this is not happening - the comparative cell is staying the same
no matter where I copy it. Is there a different way to accomplish this
without doing a conditional formatting for each individual cell?