Copying Conditional format

[ERG]

I have a row (26) of numbers that I want to compare to another row of numbers
(5), and highlight the numbers in row 26 that are below the corresponding
number in row 5 - I want the numbers in each column in row 26 to be compared
to the number in that same column in row 5 - for instance, if c26 is less
than c5, it will be red, if f26 is less than f5 it will be red - if h26 is
greater than h5, it will not be red.

When I make the condition - it reads "cell value < $c$5" and I remove the $
from before the c - then I copy that format (right click, copy, paste
special, formats) to adjacent cells and the adjacent cells are still being
compared to c$5 -

It used to work in Excel 03...

Any ideas?

 

[Bob Umlas]

In xl2007, changes to conditional formatting are often ADDED to other
formatting. I suggest you FIRST clear ALL the CF's from row 26 & start
again. You do need simply a formula (not a value) and if A26 is the active
cell, and you've selected row 26, then the formula is =A26<A5