Copy Conditional Formatting

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.

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

=A2A1

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)


"Bianca" wrote in message
...
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.

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

Malcolm...


"Peo Sjoblom" wrote in message
...
Use absolute references in your conditional formatting formulas, i.e.

=A2A1

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)


"Bianca" wrote in message
...
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.