How do I copy conditional formats so it changes cell references?

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

Guest

I want to add some conditional formatting to flag up rows containing less
than a certain number of tick boxes, but when I copy/paste the formula it
retains the original cell reference instead of changing it in the way it does
when you copy a formula. Help!
 
check that the conditional format equation does not have the absolute
reference for cells ($)
 
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

Conditional formatting offset reference 3
Conditional Formatting 3
Conditional format copying 3
Conditional Cell Formatting 5
Excel Conditional Formatting 1
copy conditional formatting range 3
Condition formats have $ sign problem copying 1
Copying a Conditional Formatting Formula 2

Back
Top