Copy Formula Is conditional format

[Paul B.]

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

 

[Bob Phillips]

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.]

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

Have you made the row number in the formula relative?

--
HTH

Bob Phillips

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

 

[Gord Dibben]

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

 

[Paul B.]

Thank you! Got it working now.

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