E
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?
(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?