Copy Conditional Formatting

[Guest]

Hi,

The sheet I am maintaining is very big. It contains 700 rows and uses all of
the columns. Ever cell has the same conditional formatting formula, only the
cell reference value within the formula is different. When I started the
sheet, it was easy. By copying the format of the cell to the other cells,
each cell would get the correct Conditional Format formula.
Now the sheet is filled in with a lot of different colours on different
cells. These colours are not allowed to change. The formula for the
Conditional Formatting for all the cells is changed. How can I change this
Conditional Formatting formula to all the cells in a way that the cell
references that appear in the Conditional Formatting formula will also change?

Thanks in advance.

 

[Peo Sjoblom]

Use absolute references in your conditional formatting formulas, i.e.

=A2>A1

change to

=A>$A$1

as an example

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[Malcolm Austin]

And one useful tip is; After typing your cell reference, press F4 to
automatically change it to absolute!

Malcolm...