Coping Formulas

  • Thread starter Thread starter Chance
  • Start date Start date
C

Chance

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
help.

Chance
 
hi, try this

go to the cell which contains the correct formula for
your conditional formatting, in the conditional
formatting dialog window change the cell reference to for
example ....if the range is b3 change this to $b$3 this
makes the reference absolute. and then copy and paste the
formula.

hth mac
 
Back
Top