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 |
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 |