If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
copying conditional formats
I've created a conditional format that colors red cell A1 if the value of
cell A1 is less than cell B1. Next, I copied this format into the cells A2:A100. EXAMPLE col A col B row1: 80 90 highlight cell A1 row2: 98 95 row3: 70 98 highlight cell A3 .... row99: 82 90 highlight cell A100 row100: 90 85 In Excel97 this copy worked fine... in Excel 2007 when I select each of the cells A2 thru A100 and examine the Rule Manager it shows the same rule comparison cell... Rule Cell Value $A2 is applied to group of cells =$A$2:$A$100. It appears to have worked correcly, in that A2 is compared to B2, A3 to B3.... A100 comared to B100. However, when I examine the conditional rules for each of cell A2 thru A100 the Rules value is always listed as $B1. Because the cell formatting result appear to work correctly... this would mean that it must be incrementing the Rule value for each cell. If this is the case, I don't feel confortable that the Rule Value is always $B1 for all these cells because I cannot be certain that the comparison is being done correctly. I would perfer to see a similar formating result like in Excel97. As a work around, I've resorted to coping the format into only one cell at a time so that each Rule value correlates with the cell, however this is a very painful process when doing individual 100 copies. Is there a simplier way of doing this format copy what will show the acual rule cell used? |
#2
|
|||
|
|||
copying conditional formats
Is there a simplier way of doing this format
copy what will show the acual rule cell used? Unfortunately, that's how Excel 2007 displays the CF rules. Doesn't make any sense to me (and many others, I'm sure!). Poorly designed. Period! -- Biff Microsoft Excel MVP "Ron" wrote in message ... I've created a conditional format that colors red cell A1 if the value of cell A1 is less than cell B1. Next, I copied this format into the cells A2:A100. EXAMPLE col A col B row1: 80 90 highlight cell A1 row2: 98 95 row3: 70 98 highlight cell A3 ... row99: 82 90 highlight cell A100 row100: 90 85 In Excel97 this copy worked fine... in Excel 2007 when I select each of the cells A2 thru A100 and examine the Rule Manager it shows the same rule comparison cell... Rule Cell Value $A2 is applied to group of cells =$A$2:$A$100. It appears to have worked correcly, in that A2 is compared to B2, A3 to B3.... A100 comared to B100. However, when I examine the conditional rules for each of cell A2 thru A100 the Rules value is always listed as $B1. Because the cell formatting result appear to work correctly... this would mean that it must be incrementing the Rule value for each cell. If this is the case, I don't feel confortable that the Rule Value is always $B1 for all these cells because I cannot be certain that the comparison is being done correctly. I would perfer to see a similar formating result like in Excel97. As a work around, I've resorted to coping the format into only one cell at a time so that each Rule value correlates with the cell, however this is a very painful process when doing individual 100 copies. Is there a simplier way of doing this format copy what will show the acual rule cell used? |
Thread Tools | |
Display Modes | |
|
|