Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying Conditional format
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying conditional format across columns | Excel Discussion (Misc queries) | |||
Conditional Format - Copying Formats | Excel Worksheet Functions | |||
Conditional format copying | Excel Worksheet Functions | |||
Copying a conditional format to several cells | Excel Discussion (Misc queries) | |||
Copying a conditional format | Excel Worksheet Functions |