Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying Conditional Formatting | Excel Discussion (Misc queries) | |||
Copying a range adjacent to Conditional Format - CF Rule adds to P | Excel Discussion (Misc queries) | |||
Copying conditional formatting...HELP PLEASE!!!! | Excel Worksheet Functions | |||
Copying Conditional Formatting | Excel Discussion (Misc queries) | |||
copying conditional formatting | Excel Worksheet Functions |