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 Formatting rule
Hi,
I'm using XL2007. I'm applying the rule that if =A$1"" the cells A1;A3 should get colored. Works fine. Now I have to copy this rule to 40 other places like c$1 / d$1 / f$1 / etc. I do this by using the format brush from a1 to c1 to d1 to f1 etc. I'm not successful. It turns out that c1 and c2 get colored instead of c1 and c3, d1 and d2 instead of d1 and d3, etc Any tip? Harry |
#2
|
|||
|
|||
Copying Conditional Formatting rule
Not sure what you want to do...
However note that if you use =A$1"" in A1... It will change to B$1 when copied right to B1 but remain as A$1 in A2... Use the appropriate combination of absolute/relative references to meet your logic.. You have four choices $A1 A$1 $A$1 A1 So that reference remains as A1 in row 1 instead of changing to B1, C1,.. as you copy across... "Hartmut (Harry) Kloppert" wrote: Hi, I'm using XL2007. I'm applying the rule that if =A$1"" the cells A1;A3 should get colored. Works fine. Now I have to copy this rule to 40 other places like c$1 / d$1 / f$1 / etc. I do this by using the format brush from a1 to c1 to d1 to f1 etc. I'm not successful. It turns out that c1 and c2 get colored instead of c1 and c3, d1 and d2 instead of d1 and d3, etc Any tip? Harry |
Thread Tools | |
Display Modes | |
|
|