Tnx all,
The solution was to reference the cells without the $ sign before them.
If I copied that cell and selected the cells I wanted to apply the
conditional format to, selected Paste Special and selected Formats and
Formula, it worked a treat.
Thanks to whoever thought of the
Hi Hylton,
Hylton Conacher (ZR1HPC) schrieb:
Hi all,
Is there a way to copy a particular cells conditional formatting rules
across a cell selection either in a row or a column?
Yes. Copy a cell, which has the conditional formatting assigned. Mark
the target and goto Edit Paste Special.
Hi Regina,
See my earlier reply to Dave in addition to the below:.
Copying and writing the conditions are not the problem.
Getting the condition to automatically increment is the problem e.g. I
have cell A1 that has the formula to add the contents of cells B1, C1
and D1. Cell A1 also has 3
Hi Hylton,
Hylton Conacher (ZR1HPC) schrieb:
Hi all,
Is there a way to copy a particular cells conditional formatting rules
across a cell selection either in a row or a column?
I have a spreadsheet with three columns of numbers, two of which require
three conditional formatting rules on each