Conditional Formats

  • Thread starter Thread starter Patricia
  • Start date Start date
P

Patricia

I put in a conditional format (=$C$8<>SUM($L$8:$W$8)) and
I want to copy that formula down the sheet, but the row
numbers do not change when I copy/paste down the other
rows. Is there a way to make the row #s change without
have to go into each row and change the formula?

Thanks
 
Patricia,

Try using

=$C8<>SUM($L8:$W8)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top