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? |
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? |
All times are GMT +1. The time now is 11:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com