Copying Conditional format
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
"ERG" wrote in message
...
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?
|