Conditional Formats

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
 
B

Bob Phillips

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)
 

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

Top