Copy Formula Is conditional format
 

I have tried using Paste Special to copy a Formula Is conditional format, but
it just copies the same cell infomation and doesn't adjust the row number.

Any ideas?

Cheers

Copy Formula Is conditional format
 

Have you made the row number in the formula relative?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Paul B." wrote in message
...
I have tried using Paste Special to copy a Formula Is conditional format,
but
it just copies the same cell infomation and doesn't adjust the row number.

Any ideas?

Cheers

Copy Formula Is conditional format
 

Sorry, I have no idea what you mean...

"Bob Phillips" wrote:

Have you made the row number in the formula relative?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Paul B." wrote in message
...
I have tried using Paste Special to copy a Formula Is conditional format,
but
it just copies the same cell infomation and doesn't adjust the row number.

Any ideas?

Cheers

Copy Formula Is conditional format
 

A2.........relative column and row

$A2......absolute column, relative row.

$A$2.......absolute column and row

A$2........relative column, absolute row


Gord Dibben MS Excel MVP


On Tue, 29 Aug 2006 14:21:02 -0700, Paul B.
wrote:

Sorry, I have no idea what you mean...

"Bob Phillips" wrote:

Have you made the row number in the formula relative?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Paul B." wrote in message
...
I have tried using Paste Special to copy a Formula Is conditional format,
but
it just copies the same cell infomation and doesn't adjust the row number.

Any ideas?

Cheers

Copy Formula Is conditional format
 

Thank you! Got it working now.

"Gord Dibben" wrote:

A2.........relative column and row

$A2......absolute column, relative row.

$A$2.......absolute column and row

A$2........relative column, absolute row


Gord Dibben MS Excel MVP


On Tue, 29 Aug 2006 14:21:02 -0700, Paul B.
wrote:

Sorry, I have no idea what you mean...

"Bob Phillips" wrote:

Have you made the row number in the formula relative?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Paul B." wrote in message
...
I have tried using Paste Special to copy a Formula Is conditional format,
but
it just copies the same cell infomation and doesn't adjust the row number.

Any ideas?

Cheers