P
Porky79
Hi all-
Possibly a simple question ...... but it is baffling me!!!
When you copy a formula in excel from one cell to another the formula
stay relative to the cell unless you lock the reference by using $.
However, the same does not seem to apply to conditional formatting
rules. They seem to stay locked to the cells that you select even if
you remove the $. i.e. if you set the formats up in colum A, drag©
the column to B - the format rules still apply to cells in Column A
rather than staying relative to teh same cells in column B.
Can anyone help? is there a way to copy conditional formats so they
stay relative as you drag and copy?
Thanks in advance
Paul
Possibly a simple question ...... but it is baffling me!!!
When you copy a formula in excel from one cell to another the formula
stay relative to the cell unless you lock the reference by using $.
However, the same does not seem to apply to conditional formatting
rules. They seem to stay locked to the cells that you select even if
you remove the $. i.e. if you set the formats up in colum A, drag©
the column to B - the format rules still apply to cells in Column A
rather than staying relative to teh same cells in column B.
Can anyone help? is there a way to copy conditional formats so they
stay relative as you drag and copy?
Thanks in advance
Paul