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