View Single Post
  #2   Report Post  
bj
 
Posts: n/a
Default How do I copy conditional formats so it changes cell references?

check that the conditional format equation does not have the absolute
reference for cells ($)

"Chuckie E." wrote:

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!