Conditional Formatting
 

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


--
gregory.barrett
------------------------------------------------------------------------
gregory.barrett's Profile: http://www.excelforum.com/member.php...o&userid=32421
View this thread: http://www.excelforum.com/showthread...hreadid=528219

Conditional Formatting
 

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.

"gregory.barrett" wrote:


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


--
gregory.barrett
------------------------------------------------------------------------
gregory.barrett's Profile: http://www.excelforum.com/member.php...o&userid=32421
View this thread: http://www.excelforum.com/showthread...hreadid=528219

Conditional Formatting
 

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

--
--Chip Smith--
MVP Wannabe :)


"gregory.barrett" wrote:


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


--
gregory.barrett
------------------------------------------------------------------------
gregory.barrett's Profile: http://www.excelforum.com/member.php...o&userid=32421
View this thread: http://www.excelforum.com/showthread...hreadid=528219

Conditional Formatting
 

that was definately it. Thanks, I never knew that the dollar signs were
anchors


--
gregory.barrett
------------------------------------------------------------------------
gregory.barrett's Profile: http://www.excelforum.com/member.php...o&userid=32421
View this thread: http://www.excelforum.com/showthread...hreadid=528219