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