conditional formatting in Excel 2007


John Keith

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
(e-mail address removed)



Per Jessen

Hi John

You are using an absolute row reference and relative column reference
(U$1). The $ sign indicate an absolute reference, so remove it before the
row reference. You can use the format painter to copy your conditional

I don't know how to get by your second problem


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question