Conditional Formatting

G

gregory.barrett

When I select a range of cells for conditional formatting it changes the
Cell Refrences. For example. I want a range of cells to have the same
conditional formatting like =A1=0 but it changes the next cell to =B1=0
and the next to =C1=0. What do I do?

Excel 2002, SP3
 
S

ShaunR1967

If it works the same as generally copying references, one method you can use
is the "$" anchor. Whatever parameter that you wish to remain constant, place
a dollar sign in front of. For example, if you want to keep the column
reference the same, write it as $A1. If you want to keep the row reference
the same, write it as A$1. For both, write $A$1.

Hope I've helped.
 
C

Chip Smith

make it so the formula is $A$1=0 that will make column A1 the constant and
wont change
 
G

gregory.barrett

that was definately it. Thanks, I never knew that the dollar signs wer
anchor
 
Top