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