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