Copy Formula Is conditional format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Have you made the row number in the formula relative?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Sorry, I have no idea what you mean...

Bob Phillips said:
Have you made the row number in the formula relative?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
Click to expand...
 
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
 
Thank you! Got it working now.

Gord Dibben said:
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
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

copy conditional formatting range 3
copying conditon formats with $ 12
Condition formats have $ sign problem copying 1
Conditional format copying 3
Conditional formula yeilds non-number result 6
Conditional Formatting 3
copying conditional formats 7
IF OR AND in same conditional formula 2

Back
Top