Coping Formulas

Giganews Newsgroups
Subject: Coping Formulas
Posted by:  Chance (jsmy…
Date: Thu, 9 Oct 2003

I have put a conditional format formula to high light
duplicate entries. The problem is for each cell it has
changed the range values in the formula. In order for it
to work I need the ranges to stay the same as in the first
cell. It works if I manually go to each cell and change
the ranges in the conditional format, but there are a lot
of rows and I don't want to go to each one. Thanks for any