Copying Conditional Formatting rule

  • Thread starter Thread starter Hartmut \(Harry\) Kloppert
  • Start date Start date
H

Hartmut \(Harry\) Kloppert

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
 
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...
 
Back
Top