View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
gregory.barrett
 
Posts: n/a
Default 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